How to replicate Azure SQL Database to Local

This Azure SQL DB tutorial explains how to replicate Azure SQL Database locally.

How to replicate Azure SQL Database to Local

Follow the below steps to replicate the Azure SQL database locally.

  1. Connect to the Azure SQL DB.
  2. Now, you must Right-click on the Database –> then select the Tasks option –> Click on the Export Data-tier Application option.
Replicate Azure SQL Database To Local

3. Now, click on the Next button and then choose the option to save to local disk on the Export settings tab. That will store a .bacpac file there.

Copy Azure SQL database to Local Server

4. You need to verify the details on the summary page. If everything is correct, click on the Previous button if you want to modify the options, or click the Finish button.

How to Copy Azure SQL database to Local Server

5. Now, as the next step, Connect to the Local SQL Server Instance.

6. Right-click on the Database –> Click on the Import Data-tier Application option. Click on the Next button on the Import Settings tab, and select the .bacpac file from the local path you have saved before.

How to Export Azure SQL Database To bak File

7. Click on the Import from local disk and select the .bacpac file you saved above. Click on the Next button, and finally, click on the Finish button.

How to Replicate Azure SQL Database To Local

8. You can see the same Database has been created successfully without any issues.

Steps to Replicate Azure SQL Database To Local

You may also like following the articles below

Wrapping Up

In this Azure article, we discussed How to replicate Azure SQL Database to Local. Thanks for reading this article !!!