"Import Data-tier Application" failed

• onlo

  SSCertifiable

  Points: 5080

  More actions

  January 16, 2018 at 7:43 pm

  #327200

  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;

  (Microsoft.SqlServer.Dac)

  Some web sites taught me typed this before you do Import Data-tier Application

  sp_configure' contained database authentication', 1; 

  GO

  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?

• Thom A

  SSC Guru

  Points: 99126

  More actions

  January 17, 2018 at 1:46 am

  #1976097

  Duplicate of https://www.sqlservercentral.com/Forums/1917506/Import-Datatier-Application-failed

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk