SQL Database export

Question

How to export and download exported database?

Answer 1

Hi @Tukenov, Almaz [Tengizchevroil]

To export Azure SQL database, you can use the Azure portal or SSMS. Here are the steps to export an Azure SQL database using the Azure portal:

1. Open the Azure portal and navigate to your SQL database.
2. Click on the "Export" button in the toolbar.
3. In the "Export database" blade, select the storage account where you want to export the database.
4. Enter a name for the storage container and a name for the BACPAC file.
5. Choose the appropriate export settings, such as the version of SQL Server to use for the export.
6. Click on the "Export" button to start the export process.
7. Once the export is complete, navigate to the storage account and container where the BACPAC file was exported. Check if you can download/save bacpac from storage account to your local.

Here is the link to the official Azure documentation that provides more information on exporting an Azure SQL database:

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql

I hope this helps! Let me know if you have any further questions.

Thank You!