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.
Table of Contents
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.
Below are the Prerequisites needed here.
- You must have an Azure Subscription or Azure Account, If you don’t have an Azure Account till now, You can create an Azure free account now.
- You must install SQL Server Management Studio on your local or dev machine.
Assuming, you are ready with all the prerequisites needed here, let’s start with the actual functionality.
Deploy SQL Database To Azure
- The first step is to open the SQL Server Management Studio (SSMS) and connect it using your credentials.
- 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.
3. Now, it will show you the below wizard, Click on the Next button on the Introduction page.
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.
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.
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.
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.
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.
You can able to see the TSINFODB database that we have deployed from the local SQL server management studio to Azure.
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
- SQL Server on Azure Virtual Machines
- 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.
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
- How to Change Azure SQL Pricing Tier using SQL Query & Azure Portal
- How To Upload SQL Database To Azure
- How To Change User ID and Password For Azure SQL Server Database
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 !!!
I am Rajkishore, and I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machine, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.