Deploy Database to Azure SQL Database

How To Deploy SQL Database To Azure

This Azure tutorial will discuss how to deploy SQL Database to Azure.

How To Deploy SQL Database To Azure

Follow the steps below to learn how to deploy SQL server database to Azure Portal using SQL Server Management Studio (SSMS).

In this article, we will use the option from the SQL Server Management Studio (SSMS) to deploy the local SQL database to Azure.

Before starting the actual functionality, we should know the Prerequisites needed here.

Prerequisites

Below are the Prerequisites needed here.

Let’s start with the actual functionality if you are ready with all the prerequisites.

Deploy SQL Database To Azure

  1. The first step is to open the SQL Server Management Studio (SSMS) and connect it using your credentials.
  2. Now, to deploy the SQL Database to Azure, Right-click on the database name –> select the Tasks option –> Click on Deploy Database to Microsoft Azure SQL Database.
how to deploy sql server database

3. Now, it will show you the below wizard, Click on the Next button on the Introduction page.

deploy sql server

4. On the Deployment Settings tab, click on the Connect button, Specify the Azure SQL Database server name, and click on the Connect button on the Connect to server window as shown below.

deploy sql server database to azure

5. Specify the new Database name, specify the edition of Microsoft Azure SQL Database, Provide the maximum database size and the service objective, and then click on the Next button on the Deployment Settings tab as shown below.

deploy database to microsoft azure sql database

6. Below is the Summary tab, where you can verify if all the provided details are correct, if you want to modify any of the options, you can click on the Previous button, or else click on the Finish button to finish the complete process.

deploy sql

7. On the Results tab, you will see the Operation complete message with all the parameters as a success, and in case of any issue, it will show you an error instead of success.

how to deploy sql database in azure

This is How To Deploy SQL Database To Azure using SQL Server Management Studio.

Validate The Local Database In Azure

To ensure the deployment is completed successfully, Let’s log in to the Azure Portal to verify if the new database has been deployed successfully.

  • Log in to the Azure Portal (https://portal.azure.com/).
  • Search for the SQL databases and then click on the search result SQL databases.
deploy azure sql database

You can see the TSINFODB database that we have deployed from the local SQL server management studio to Azure.

sql server deploy

Click on the database name to find the complete details.

FAQs

What is the size of an SQL database

The maximum size of the Azure SQL database depends on which tier or edition of the Azure SQL Database you are using.

  • If you are using Azure SQL database basic edition, the maximum size it supports is up to 2 GB.
  • If you are using the Standard tier of Azure SQL database, it supports up to 250 GB.
  • If you use the Azure SQL Database Premium tier, it supports up to 1 TB.

This is all about the maximum size of the Azure SQL Database.

How to host a Database on Azure

We have already discussed above how to deploy SQL Database to Azure. You can refer to the above section for the steps to host a database on Azure.

You may also like following the articles below

Wrapping Up

In this article, we have discussed how to deploy SQL database to Azure and Azure SQL Database Deployment Options. I hope you have enjoyed this article !!!