debugsqlMinor
Bacpac Import fails with error 'The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation'
Viewed 0 times
failserrorthecatalogcollationwithcontainpropertyelementsqldatabaseoptionsdoes
Problem
I want to restore some production azure database on my local machine for development purposes.
So I exported the production database to a
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.
Can someone please tell me what does this error means & how to fix it?
Thanks in advance.
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.
Can someone please tell me what does this error means & how to fix it?
Thanks in advance.
Solution
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/
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/
Context
StackExchange Database Administrators Q#208775, answer score: 7
Revisions (0)
No revisions yet.