Database Migration Azure SQL Database To Local SQL Server

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

  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


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

  1. Enter the credentials to connect to the target / destination SQL Server.
  1. Fill in details to specify the following fields:
  • New database name
  • File name for the temporary BACPAC
  1. Complete the Wizard.