Export Azure SQL database and import on local SQL Server
Hi All,
In this Blog Article i show how you can Export an Azure SQL Database and import it back on your local SQL Server
In the Azure Portal go to your SQL database and hit "Export"
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_01.jpg)
You need to set the Storage Target for your Export
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_02.jpg)
I create a new container at my Storage Account
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_03.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_04.jpg)
Once the export starts it takes a while until the Data is exportet
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_05.jpg)
Wait until its completed
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_06.jpg)
Then check your Azure Storage
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_07.jpg)
Now you are able to download the *.bacpac File
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_08.jpg)
If you add *.zip do the *.bacpac File you can see that it is actually a ZIP File that contains the Database Schema and the Data
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_09.jpg)
For each Table is a Folder
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_10.jpg)
In the Folder the Data is stored in a *.bcp file
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_11.jpg)
Import the Database into your SQL Server. Select Databases and from the Context Menu choose "Import Data-tier Application".
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_12.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_13.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_14.jpg)
Maybe you need to adjust the Database Name
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_15.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_16.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_17.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_18.jpg)
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_19.jpg)
And here it is fully restored on your local SQL Server
![](https://icewolffile.blob.core.windows.net/$web/202202/Azure_SQLDB_Export_20.jpg)
Regards
Andres Bohren
![](https://icewolffile.blob.core.windows.net/$web/logos/azure_logo.png)