This Azure tutorial will discuss how to deploy SQL Database to Azure.
Table of Contents
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.
- 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.
- You must install SQL Server Management Studio on your local or dev machine.
Let’s start with the actual functionality if you are ready with all the prerequisites.
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 database name –> 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
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.
You can 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.
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
- 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
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 !!!
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.