January 16, 2018 at 7:38 pm
I tried to import an Azure generated bacpac file to my local SQL Server 2016 machine but got the following error all the time:
Could not import package.
Warning SQL 72012: The object xxx exists in the target, butit will not be dropped even though you selected the ‘Generate drop statementsfor objects that are in the target database but that are not in the source’check box.
Error SQL 72014: .Net SqlClient Data Provider: msg 33161,Level 15, State 1, Line 1 Database master keys without password are not supportedin this version of SQL Server.
Error SQL 72045: Script execution error. The executedscript: CREATE MASTER KEY;
(Microsoft.SqlServer.Dac)
Some web sites taught me typed this before you do Import Data-tier Application
sp_configure'contained database authentication', 1;
GO
RECONFIGURE;
GO
But still failed.
May I know is it possible to import an Azure bacpac file into an on-premise SQL Server?
If yes, what are the proper procedures?
January 17, 2018 at 10:10 am
the error looks like you have a DMK in Azure without a password, which isn't allowed in an on-premise instance. I exported a DTA from Azure and imported into SQL 2016 without an issue. I think in your case it's data dependent.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply