Menu
I'm trying to restore database created as the BACPAC on Azure.
But it gives me following error:
The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation.
Full error info :
TITLE: Microsoft SQL Server Management Studio
Could not load schema model from package. (Microsoft.SqlServer.Dac)
INFORMATION:
The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation. (Microsoft.Data.Tools.Schema.Sql)
I am restoring it on SQL Server 2014. I have tried to use both Sql Server Management Studio 2014 and 2017.
Any one can help?
UPDATE: This fix doesn't work for this case:
My error is regarding the CatalogCollation and not the QueryStoreStaleQueryThreshold...
246
To import from a BACPAC file into a new single database using the Azure portal, open the appropriate server page and then, on the toolbar, select Import database. Select the storage account and the container for the BACPAC file and then select the BACPAC file from which to import.
You can not directly restore this type of file but have to follow a few steps to import it into your database with us. To do this you will need the latest SQL Server Management Studio (SSMS), a local instance of SQL Server, either Express or any full version, and your . bacpac file.
bak file is larger compared to the . bacpac file because it takes a full copy of data contained on the database files. Azure SQL Database doesn't allow you to take native backups ( . bak ) as it uses a different technology for backups.
To recover a database to a point in time by using the Azure portal, open the database overview page and select Restore on the toolbar. Choose the backup source, and then select the point-in-time backup point from which a new database will be created.
If you import a Bacpac file to Azure SQL and there were errors like user or table with same name already exists, then you need to check the collation of the source database on on-prem or Managed instance servers.
Azure SQL Managed Instance does not currently support exporting a database to a BACPAC file using Azure PowerShell. To export a managed instance into a BACPAC file, use SQL Server Management Studio or SQLPackage. Use the New-AzSqlDatabaseExport cmdlet to submit an export database request to the Azure SQL Database service.
When importing bacpacs in SQL Azure, we sometimes see a dbo._TransactionIndex_ ( GUID attached) table and when looking through our database, see that we're missing data.
For example you cannot take a SQL Server backup and restore it to Azure SQL or the other way round. (You can restore a SQL Server backup on Azure SQL Managed Instance, which is a “special” edition of Azure SQL that specifically aim to simplify lift-and-shift migrations)
It's always best to use the latest SSMS version with Azure SQL Database to keep up with incremental changes. The problem is that you were using the older version of SSMS (17.3).
You can get the latest SSMS version from the menu (Tools--->Check for updates).
51
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
