Post1

Working with SQL Server Database on Microsoft Azure (Part 3)

Posted by Vivek Shankar

This is the third and the final part of the series. We started with learning to register MS Azure and create SQL database & objects. Progressed to migrating the on-premise database to MS Azure using Export Data-tier Application. Now in the last installment, we’ll learn to migrate the on-premise database to Azure using Deploy Database to Windows Azure SQL Database wizard.

The primary difference between the two methods of migrating the on-premise database to MS Azure is that the ‘Deploy’ option requires an existing database server in Azure to which the on-premise database is directly deployed. The database is exported to a file, which is then directly loaded on to an Azure Blob Storage account.

However, both the methods of migration require an Azure Blob Storage account with a container and an Azure SQL server.

Prerequisites for Migration of DB

Before migrating the database on to MS Azure, ensure you have the following:

  • An Azure subscription.
  • ‘Azure Ready’ database; i.e., the database you want to migrate to Azure must be compatible.

Migration via Wizard

  • Right-click the database and select Deploy Database to Windows Azure SQL Database as shown in the following figure.

  • It will open Deploy Database Wizard as depicted in the following figure.

  • The server information for the Azure SQL Database server is shown in the following figure. The BACPAC file is created locally and applied on the Azure SQL Server. It, therefore, requires you to store the BACPAC file in a temporary place on the server.

  • Review the settings as shown in the following figure and click the Finish button.

  • Wait for the process to complete as shown in the following two figures. At this stage, the wizard will validate the database, create the BACPAC file and apply the Azure SQL Server to create the database.

  • After the process is completed, click the Close button. Connect to the Azure portal and you will see the migrated database in the list as highlighted in the following figure.

Closing Lines

Migrating the on-premise database to MS Azure via Wizard is highly preferred for its simplicity. We hope this method of migrating the database gives you another reason to ponder over MS Azure. Implement this method to migrate your data to MS Azure and let us know your experience in the comments below.

With that, we finish our trilogy of Working with SQL Server Database on Microsoft Azure.

Will catch up in the next blog. Until then, Happy Learning!

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *