How to Change Azure SQL Pricing Tier using SQL Query & Azure Portal

How to Change Azure SQL Pricing Tier using SQL Query & Azure Portal

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.

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 to see the query has been executed successfully.

How to Change The Azure SQL Pricing Tier using SQL Query

Now, when I have clicked on the Overview tab, I can see the pricing tier of my Azure SQL database has been changed successfully. Refer to the screenshot below.

write an sql query to Change The Azure SQL Pricing Tier

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.
Change The Azure SQL Pricing Tier
  • Click on the database from the lists.
How to change the Azure SQL pricing tier
  • 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.
How to change the Azure SQL pricing tier using Azure Portal

Change Azure SQL Pricing Tier – Video Tutorial

You may also like following the articles below

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 !!!