Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025

Question

I have received this mail to upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025.

When I looked at the ARM template, I found that there are only database advisors who are using the old api version i.e. 2014-04-01. There aren't any other resources.

I downloaded the ARM Template from Azure Portal and updated the api version in that and tried to redeploy the same. But that has failed with following error.

The HTTP method 'PUT' is not supported on the resource 'Microsoft.Sql/servers/databases/advisors/CreateIndex'.

Post that, I have three questions:

1. Are database advisors' API versions managed automatically by Microsoft?
2. If not, do I need to update them?
3. If need to update then how?

PS: FYI, I do not have usage of Azure SQL Database management APIs anywhere in my azure ecosystem.

Answer 1

Hello Taukirahmed Khatri, this is a broader broadcast message from Microsoft that's sent to all customers who have registered for Microsoft.SQL in their respective Azure subscriptions. So, there isn't any need for you to fear about this notification. As regards to updating the database advisors, please refer here - https://learn.microsoft.com/en-us/rest/api/sql/database-advisors/update?view=rest-sql-2021-11-01&tabs=HTTP

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @Taukirahmed Khatri

Customers who have registered for Microsoft.SQL will receive these notifications, Even though if the customer did not create the Azure SQL DB they receive it due to the Microsft.SQL is registered for the subscription. it's a general notification to existing SQL Database users to transition the new APIs by October 2025.

you can open Azure portal -> Subscriptions -> Resource Providers, and search for "Microsoft.Sql", if this is registered, you will receive the notification. If there is no SQL resource created in the subscription, you can ignore the notification email or unregister the resource provider to avoid confusion.

Until 31 October 2025, you can continue to use Microsoft.SQL 2014-04-01 APIs, templates, SDKs, and programs without impact.  You can transition to a newer stable version of Microsoft.SQL APIs any time before 31 October 2025.

Here is the reference link 

https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0

https://stackoverflow.com/questions/74292401/how-to-react-to-message-from-microsoft-regarding-updating-apis

Thank You!