0

After enabling auditing and threat detection in Azure for my Sql Server database, I can no longer extract my database dacpac using sqlPackage.exe as I'm presented with this error:

The element ##MS_DatabaseMasterKey## is not supported in Microsoft Azure SQL Database v12.

Any ideas?

dhughes
  • 645
  • 1
  • 7
  • 19

1 Answers1

1

Good news! That's been fixed in newer versions of SqlPackage.exe. You can download the latest version of SqlPackage.exe here: https://www.microsoft.com/en-us/download/details.aspx?id=54106

Note that this version installs SqlPackage under the 130 folder in Microsoft Sql Server, where earlier versions might be found in the 120 or 110 folder.

Steven Green
  • 3,387
  • 14
  • 17
  • Apologies for the late reply but updating to the latest version of sqlPackage resolved my error. Thanks! – dhughes Nov 29 '16 at 01:50