apart from the _WA statistics won't be export , anything else are not included for exporting the bacpac ?
apart from the _WA statistics won't be export , anything else are not included for exporting the bacpac ?
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.
7 people are following this question.