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

7.png

After connecting choose Import Data-tier Application option

8.png

9.png

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

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

11.png

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

12.png

13.png

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

Happy Programming.

Advertisements

Technical Lead for Microsoft Technologies especially in Azure, ASP.Net and in Angular JS.

Posted in Azure

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s