Well, In this article, we will write a SQL query to change the Azure SQL pricing tier, and along with that, we will also discuss how to change the Azure SQL pricing tier using Azure Portal.
Table of Contents
How to Change Azure SQL Pricing Tier using SQL Query & Azure Portal
Let’s write the SQL query to change the Azure SQL pricing tier and execute that and then we will see if we have done the steps successfully and then we will discuss how to do the same thing using the Azure Portal.
Change Azure SQL Pricing Tier using SQL Query
You can write the SQL query like below and then refer to the example below on the implementation.
ALTER DATABASE [<Your Database Name>] MODIFY(EDITION='< Database edition>' , SERVICE_OBJECTIVE='<TheserviceObjective>')Example
You can run the below query to change the pricing tier of the TsInfo Azure SQL database to Basic from General Purpose.
ALTER DATABASE [TsInfo] MODIFY(EDITION='Standard' , SERVICE_OBJECTIVE='S1') Click on the Query editor (preview) from the left navigation on the SQL database page.
Paste the above query on the Query window –> then click on the Run button and you can able to see the query has been executed successfully.
Now when I have clicked on the Overview tab, and could able to see the pricing tier of my Azure SQL database has been changed successfully. Refer to the below screenshot.
How to Change The Azure SQL Pricing Tier Using Azure Portal
Follow the below steps
- Log in to the Azure Portal.
- Search for the SQL databases in the Azure Portal and then click on the search result SQL databases.
- Click on the database from the lists.
- On the SQL database page, click on the Compute + storage link from the left navigation under Settings. Select the desired Service tier from the Service tier dropdown as highlighted below and you are done with the steps.
Change Azure SQL Pricing Tier – Video Tutorial
You may also like following the below articles
- How to create an Azure SQL database
- How To Change User Id And Password For Azure SQL Server Database
- How to set an Azure Active Directory user or group as an Azure SQL Administrator
Wrapping Up
In this Azure article, we discussed how to change the Azure SQL pricing tier using SQL Query & Azure Portal. Thanks for reading this article !!!