SQL Database export

Tukenov, Almaz [Tengizchevroil] 0 Reputation points
2024-06-21T12:47:40.7866667+00:00

How to export and download exported database?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2024-06-21T12:53:13.87+00:00

    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!

    0 comments No comments