How To Deploy SQL Database To Azure

How To Deploy SQL Database To Azure

In this Azure tutorial, we will discuss How To Deploy SQL Database To Azure. Along with this, we will also discuss a few other topics like Azure SQL Database Deployment Options.

How To Deploy SQL Database To Azure

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

Note that, 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.

Assuming, you are ready with all the prerequisites needed here, let’s start with the actual functionality.

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 name of the database –> select the Tasks option –> Click on Deploy Database to Microsoft Azure SQL Database.
How To Publish SQL Database To Azure

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

Deploy a SQL Database To Azure

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 a sql database to azure using sql server management studio

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.

how to deploy a database from local to Azure

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.

how to deploy database from local to Azure

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.

deploy sql database to azure using sql server management studio

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

Validate The Local Database In Azure

Now, to make sure that 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.
Validate The Local Database In Azure

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

ssms deploy database to azure sql database

Click on the database name to find the complete details.

Azure SQL Database Deployment Options

When you are thinking of deploying your SQL database to Azure, you should consider two key deployment options in this case. Those are as below

  1. SQL Server on Azure Virtual Machines
  2. Microsoft Azure SQL Database

Each deployment option has its own benefits and differs in terms of its costs and the control they actually provides you with respect to the platform. Best on your requirements, you need to choose the best deployment options that actually suit you.

SQL Server on Azure Virtual Machines

SQL Server on Azure Virtual Machines deployment option is an infrastructure as a service (IaaS) solution that runs on a set of standard hardware that is owned and maintained by Microsoft, you do not need to take any headache for the maintenance and infrastructure. Another advantage is you can pay-as-you-go model that is already included with your SQL server license.

One more recommendation from Microsoft is, that it is always better to use these deployment options if you are trying to migrate the applications that actually require OS-level access. This is one of the best options if you want fast migration with low cost and the coolest option for rapid development.

Microsoft Azure SQL Database

Microsoft Azure SQL Database is a relational database service from Microsoft. It is basically a platform as a service (PaaS). This also runs on a set of standard hardware and software that is owned and maintained by Microsoft, you do not need to take any headache for the maintenance part.

One more advantage with Microsoft Azure SQL Database is, this is also based on the pay-as-you-go model. You can also deploy an Azure SQL Database Managed Instance within Azure SQL Database.

The coolest benefit of the Azure SQL Database is, that it is nearly 100% compatible with the on-premises SQL Server that helps you a lot during the migration of local SQL database to Azure.

Note that the recommendation from Microsoft is is better to choose this deployment option when you are working with modern cloud applications and in case you have any time constraints for the development activity.

Now, based on your requirement, you decide which Azure SQL Database Deployment Options suit best for you.

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, then the maximum size it supports is up to 2 GB.
  • In case you are using the Standard tier of Azure SQL database, then it supports up to 250 GB.
  • If you are using the Azure SQL Database Premium tier, then 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 below articles

Wrapping Up

Well, in this article, we have discussed, How To Deploy SQL Database To Azure, and Azure SQL Database Deployment Options. Hope you have enjoyed this article !!!