Database Migration Azure SQL Database To Local SQL Server

News Knowledge Base
1

How to migrate the Azure SQL Database to Local SQL Server?

Migrating an Azure SQL Database to a local SQL Server involves several steps to ensure a smooth transition of your data and configurations. Here’s a general approach to achieve this:

  1. Ensure to already have provisioned an Azure SQL Database
  2. Login to Azure DB
  3. Select the database which is required to be migrated to local server

ssms_open_dbmigrationwizard_azure.png662×385 31.1 KB

  1. In the Deploy Database Wizard, click Next, then click Connect to connect to the target / destination SQL Server Database.

ssms_open_dbmigrationwizard_2.png662×603 24.8 KB

  1. Enter the credentials to connect to the target / destination SQL Server.
ssms_open_dbmigrationwizard_3.png662×603 22.3 KB
  1. Fill in details to specify the following fields:
  • New database name
  • File name for the temporary BACPAC
ssms_open_dbmigrationwizard_4.png662×603 26.6 KB
  1. Complete the Wizard.

By following these steps, you should be able to migrate your Azure SQL Database to a local SQL Server effectively. Each step ensures that your database schema and data are transferred accurately while considering the differences between the Azure cloud environment and a local server setup.

2

Great tutorial! Another tool worth considering for this task is SQLWays, which can help streamline database migrations between Azure SQL Database and local SQL Server