Introduction

This article will explain about migrating the SQL Server database to Azure SQL Server. In this demo we’ll discuss about the steps for importing and exporting SQL data from on-premises database to Cloud database,  using  Import and Export Wizard  is a simple way to migrate your database.

Export to bacpac file in SQL Server Management Studio (SSMS)

  1. Open and connect database file in SQL Server Management Studio (SSMS).

  2. To export a database file Right click on the name of the database. In the context-menu select Tasks > Export Data-tier Application

  3. The option will open the wizard. Click Next > Introduction page go to the Export Settings.

  4. The Export Settings are requested to the location to save bacpac file.

      

    • You can save to the local disk or Azure storage account. Since You don't have an Azure storage account You'll save the bacpac file and file name to local disk.

    • You want (Migrate full database), You'll selected all objects. After the location. Click Next button.

  5. The current Summary page. You can verify and confirm the settings. after all information is correct, click the Finish button.

  6. Start the Export. Successful export looks like. Click the Close button exit the bacpac export wizard.

      

 2.Import a bacpac file to Azure SQL

  1. To create a (Create a SQL database Azure)SQL Azure database form a bacpac file in SQL Serevr Management Studio (SSMS), Connect to the SQL Azure Server.

  2. After connect, Object Explorer pane, right-click the database folder. Select Import Data-tier 
  3. The option will open the wizard. Click Next > Introduction page go to the Import Settings.

  4. The Import Settings are requested to the bacpac file to import.

    • You have exported the bacpac file to you local disk, You'll import it.

    • After click Next button

  5. The Database Settings page are requested to configure the new Azure SQL database by providing the new database name, The maximum database size , Click the Next button.

  6. The Summary page, confirm the correct information. Click the Finish button to the start the Import.

  7. Successful Import looks like. Click the Close button exit the bacpac export wizard.

3.Import Validate Azure SQL

  1. If You can confirm the new databse has been created in the Azure SQL Server.

  2. And the Microsoft Azure Portal by checking in the respective Azure SQL Server.

Summary: 

In this demo we learned how to migrate our on-premises database to Azure database using Import and Export Wizard. If you have any clarification, please write me.