Create Contained Database from a BACPAC File

Posted: January 22, 2024 | Author: | Filed under: Uncategorized | Leave a comment

The target Instance needs to have this value to 1:

sp_configure ‘contained database authentication’, 1;
GO
RECONFIGURE;
GO

From the Azure SQL Database within SSMS:

>>Tasks>Export Data-tier Application>> to save exported database Bacpac file;

then Import to create a new database locally on a 2019 Instance from SSMS.