Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

In this article, we will discuss how to deploy a database from local to Azure using Deploy database to SQL Azure option in SQL Server.

Introduction

In this article, we will discuss how to deploy a database from local to Azure using deploy database to SQL Azure option in SQL Server.

Here, we are not using .bak or .bacpac file. Rather, we are using "deploy the database to SQL Azure" option in SQL Server.

Prerequisites

  • Microsoft Azure account.
  • SQL Server Management Studio.

Deploy Database from local to Azure

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

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

  2. To export a database file to Azure, right click on the name of the database. In the context menu, select tasks > deploy the database to SQL Azure.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

  3. This will open the wizard. Click next in the introduction page and go to the deployment settings.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

  4. The deployment settings page is used to deploy the database from local into Azure by using Azure credentials.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server
    • You need to give Azure server name, login, and password. You can also change the database name in the new database name textbox.

      Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

    • Click Next.

      Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server
  1. The summary page looks like below. After all the information is verified, click Finish.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

  2. It starts deploying now to Azure. Click the Close button to exit the wizard.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

Validating local database in Azure

  1. Log into the Azure portal and in the left panel click on SQL databases and there you can see the database.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

Note:-

  1. If you are using SQL Server 2012, then in the step-2, you need to select deploy database to SQL azure... option in SQL Server.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server

  2. But if you are using any higher version of SQL Server like 2014 or 2016 then in step 2 you need to select deploy database to Microsoft Azure SQL database  option in SQL Server.

    Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server