Skip to content

Latest commit

 

History

History
88 lines (66 loc) · 3.67 KB

sql-database-export-portal.md

File metadata and controls

88 lines (66 loc) · 3.67 KB
title description services documentationcenter author manager editor ms.assetid ms.service ms.custom ms.devlang ms.date ms.author ms.workload ms.topic ms.tgt_pltfrm
Azure portal: Export an Azure SQL database to a BACPAC file | Microsoft Docs
Export an Azure SQL database to a BACPAC file using the Azure Portal
sql-database
CarlRabeler
jhubbard
sql-database
migrate and move
NA
02/07/2017
carlrab
data-management
article
NA

Export an Azure SQL database to a BACPAC file using the Azure portal

This article provides directions for exporting your Azure SQL database to a BACPAC file (stored in Azure blob storage) using the Azure portal. For an overview of exporting to a BACPAC file, see Export to a BACPAC.

Note

You can also export your Azure SQL database file to a BACPAC file using SQL Server Management Studio, PowerShell or SQLPackage.

Prerequisites

To complete this article, you need the following:

Export your database

  1. Go to the Azure portal.

  2. Open the SQL Database blade for the database you want to export.

  3. Ensure that no transactions will occur during the export.

    [!IMPORTANT] To guarantee a transactionally consistent BACPAC file, a good method is to create a copy of your database and then export from the database copy.

  4. Click SQL databases.

  5. Click the database to archive.

  6. In the SQL Database blade, click Export to open the Export database blade:

    export button

  7. Click Storage and select your storage account and blob container to store the BACPAC:

    export database

  8. Select your authentication type.

  9. Enter the appropriate authentication credentials for the Azure SQL server containing the database you are exporting.

  10. Click OK to export the database. Clicking OK creates an export database request and submits it to the service. The length of time the export takes depends on the size and complexity of your database, and your service level.

  11. View the notification you receive.

export notification

Monitor the progress of the export operation

  1. Click SQL servers.

  2. Click the server containing the original (source) database you archived.

  3. Scroll down to Operations.

  4. In the SQL server blade click Import/Export history:

    import export history

Verify the BACPAC is in your storage container

  1. Click Storage accounts.

  2. Click the storage account where you stored the BACPAC archive.

  3. Click Containers and select the container you exported the database into for details (you can download and save the BACPAC from here).

    .bacpac file details

Next steps