Migrate Azure SQL DB to Native SQL Server

This article will help you to transfer your DB from Azure SQL Server to On-Premise SQL server.

Export Azure SQL Database

Connect to your Azure SQL from On-Premise SSMS

1

Choose menu Export Data-Tier Application from Tasks

2.png

You can see the below screen

3.png

Click on Next, and Save the ‘bacpac’ file to a convenient location.

4.png

Click Next to proceed and it will generate the bacpac file as showed below.

5.png

Click Finish and exit.

6.png

Import Azure SQL Database

Next step is to import the bacpac to Local SQL server.

Open SSMS and connect to your Local Server as below

44.png

After connecting choose Import Data-tier Application option

45.png

9.png

Click on Next and choose the ‘bacpac’ file you have created before.

3.png

Next it will show the .mdf and .ldf file locations. You can choose the convenient location from this option.

46.png

Click Next. this will restore the DB with data in your Local SQL server from Cloud.

12.png

47.png

Hope this article will help you to understand how you can move database from Azure to local SQL Server.

Happy Programming.

%d bloggers like this: