Create Contained Database from a BACPAC File
Posted: January 22, 2024 Filed under: Uncategorized Leave a commentThe 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.