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, bu tit will not be dropped even though you selected the ‘Generate drop statements for 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 supported in this version of SQL Server.
Error SQL 72045:Script execution error. The executed script: CREATE MASTER KEY;
Some web sites taught me typed this before you do Import Data-tier Application
sp_configure' contained database authentication', 1;
May I know is it possible to import an Azure generated bacpac file to an on-premise SQL Server machine?
If yes, what the proper procedures are?