question

sakuraime avatar image
1 Vote"
sakuraime asked AlbertoMorillo edited

BACPAC export from Azure sql database

apart from the _WA statistics won't be export , anything else are not included for exporting the bacpac ?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

If your database is using Cell-Level Encryption you may lose keys when migrating data to Azure SQL using import/export (bacpac). See the article, Recommendations for using Cell Level Encryption in Azure SQL Database on how to prevent losing keys when migrating data, and for other best practice guidance.

You may also lose data when a database is modified while the export process of the database (to create the bacpac) is running, Bacpacs are not guaranteed to contain transactionally consistent data. All write access to the source database must be stopped before the export operation starts. Verify that no dbo.TransactionIndex table exists on your database when importing a bacpac, that means you may be missing data.

Some users have reported creating a bacpac using the Export option on Azure portal, may not export some indexes also. You may lose some indexes as explained here.

Timestamp values on your database can suffer changes as explained here.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.