Sqlserver

| 分类 Database  | 标签 sqlserver 

Restore

SQLCMD -S localhost -U sa -P sa -Q "RESTORE DATABASE newDbName FROM disk='e:\sqlserver-backup\backupFileName.bak' WITH RECOVERY, MOVE 'OriginDbName' TO 'e:\sqlserver-data\newDbName.mdf', MOVE 'OriginDbName_Log' TO 'e:\sqlserver-data\newDbName.ldf'"

Table Name

SELECT 'dbcc CHECKIDENT(['+ table_name +'], reseed);'FROM information_schema.tables WHERE table_type = 'base table'

Script sqlserver

mssql-scripter -S dev1-wp-genDb -U sa -P sa -d dbName --exclude-use-database  --exclude-headers> 1.sql

上一篇     下一篇