2024年1月

cd "C:\Temp\sqlpackage-win7-x64-en-US-15.0.5084.2"
SqlPackage.exe /a:import /sf:C:\Temp\test.bacpac /tsn:. /tdn:AxDB_202308188 /TargetTrustServerCertificate:True /p:CommandTimeout=7200

//kill all conections.

-- Create the sql to kill the active database connections 

declare @execSql varchar(1000), @databaseName varchar(100)
-- Set the database name for which to kill the connections
set @databaseName = 'AxDB'
set @execSql = ''

select @execSql = @execSql + 'kill ' + convert(char(10), spid) + ' '
from master.dbo.sysprocesses where db_name(dbid) = @databaseName
and DBID <> 0
and spid <> @@spid exec(@execSql)
GO

-- modified DB name.

ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE --单用户模式
ALTER DATABASE AxDB MODIFY NAME = AxDB_Dev240228
ALTER DATABASE AxDB_DEL SET MULTI_USER --多用户模式

导入Bak文件
RESTORE DATABASE [DbTest]
FROM

disk = N'C:\File\bak.bak'

WITH

FILE =1,
REPLACE,
RECOVERY,
STATS=5;