使用 sqlpackage 备份和还原 SQL Server

Clear Love 6/19/2021 sqlserver

SqlPackage (opens new window)。

# 备份

sqlpackage.exe /TargetFile:"D:\docker\SQL Server\sqldb-coredx-runtime-ac-dev001.bacpac" /Action:Export /SourceServerName:"127.0.0.1" /SourceUser:"sa" /SourcePassword:"!SqlServer2" /SourceDatabaseName:"mdmDB"

1

# 还原

sqlpackage.exe /SourceFile:"D:\docker\SQL Server\sqldb-coredx-runtime-ac-dev001.bacpac" /Action:Import /TargetServerName:"127.0.0.1" /TargetUser:"sa" /TargetPassword:"!SqlServer2" /TargetDatabaseName:"mdmDB"

1