Az AQL Database 20140-04-01 APIs will be retired on 31 Oct 2025

Question

I received an email about this in August. I have one such SQL DB and SQL Server pair in a resource group called Default-SQL-EastUS. The email says I need to update my resources, i.e. upgrade any Azure SQL Database resources that use 2014-04-01 APIs to a newer stable version....

How do I do such an upgrade? Is there a document? And what is this SQL resource used for. I do not use it directly. Is it something that is present on each Azure account. My Azure account comes with my Visual Studio Professional subscription.

Thanks,

George

Answer 1

@George Stevens
Thank you for the question and for using Microsoft Q&A platform.

To upgrade your Azure SQL Database resources from the 2014-04-01 APIs to a newer version, you can follow these steps:

1. Update the API version:
   • Modify your ARM templates, scripts, or tools to use a newer API version. For example, update the apiVersion parameter in your ARM templates to a more recent version like 2021-02-01.
   Redeploy the resources:
   • After updating the API version in your templates or scripts, redeploy the resources to apply the changes.

For detailed guidance, you can refer to the following links:
https://learn.microsoft.com/en-us/rest/api/sql/retirement
https://learn.microsoft.com/en-us/answers/questions/1072411/how-do-i-update-an-azure-sql-database-to-a-newer-v

Hope this helps. Please let us know if you have any further questions.