3

I want to restore some production azure database on my local machine for development purposes. So I exported the production database to a .bacpack file & downloaded that file on local. Now I am trying to restore that file on my local machine using sqlpackage utility but it is throwing following error

*** Error importing database:An error occurred during deployment plan generation. Deployment cannot continue. The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation.

enter image description here

Can someone please tell me what does this error means & how to fix it?

Thanks in advance.

  • It's especially important to stay current with updates when using Azure SQL Database. Make sure you have the latest version of SSDT for VS 2017 installed, which is 15.7.3 as of this writing. From the VS 2017 menu, Help-->Check for Updates. – Dan Guzman Jun 5 '18 at 11:02
  • It seems you may need to update Microsoft SQL Server Data-Tier Application Framework on your computer. Please download the latest version here. After installation, you will find it on the following path C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe” and updates independently of SSDT / SSMS. – Alberto Morillo Jun 5 '18 at 16:06
5

This has been fixed as part of build 14.0.17320.0 of SSMS. Please update to the latest version.

You can read more about here: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/02/15/what-will-happen-with-catalog_collation-and-case-sensitive-vs-case-insensitive/

2

Install a later version of the Data Tier Application framework eg

https://www.microsoft.com/en-us/download/details.aspx?id=55088

That way you don't necessarily have to do a full upgrade, just use this standalone version..

An example import command would be:

"C:\Program Files\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe" /a:Import /tdn:NEWDBNAME /tp:SQLSERVERUSERPASSWORD /tsn:SQLSERVERINSTANCE /tu:SQLSERVERUSERPASSWORD /sf:"C:\Temp\BACPACFILENAME.bacpac"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.