Sql-server – Bacpac Import fails with error ‘The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation’

azure-sql-databasebacpacrestoresql server

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.

Best Answer

This has been fixed as part of build 14.0.17230.0 (not 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/

Related Question