Recently, I got the opportunity to deploy the SQL Server database to Azure. This Azure tutorial will discuss how to deploy SQL Database to Azure.
Table of Contents
How To Deploy SQL Database To Azure
Here, we will learn to deploy a SQL Server database to the Azure Portal using SQL Server Management Studio (SSMS).In this article, we will utilize the SQL Server Management Studio (SSMS) feature to deploy a local SQL database to Azure. Before starting the actual functionality, we should be aware of the Prerequisites needed here.
Prerequisites
Below are the Prerequisites needed here.
- You must have an Azure Subscription or an Azure Account. If you don’t have an Azure Account yet, you can create a free Azure 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.
To deploy SQL database to Azure, follow the steps below.
- 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 wizard below. 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, select the edition of Microsoft Azure SQL Database, provide the maximum database size, and specify the service objective. Then, click 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 the Previous button. Alternatively, click the Finish button to complete the process.
7. On the Results tab, you will see the ‘Operation complete’ message with all parameters listed as successful. In case of any issue, it will display an error instead of success.
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 an Azure SQL database depends on the tier or edition of Azure SQL Database you are using.
- If you are using the 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. Refer to the above section for the steps to host a database on Azure.
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 !!!
You may also like the following 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
- Azure SQL Database Deployment Options
I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, 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.
