How do I update an Azure SQL Database to a newer version of the resource API?

Question

I got this email from Azure

Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
You're receiving this email because you use Azure SQL Database APIs.
To improve performance and security, we're updating Azure SQL Database APIs. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You'll need to update your resources, including templates, tools, scripts, and programs, to use a newer API version by then. Any API calls still using the older versions after that date will stop working until you've updated them.
Required action
To avoid potential service disruptions, upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

But how do I actually update the SQL Database resource? Redeploy, or it there a way to update it in place.

Answer 1

Hi @Arve Svendsen

actually there a some questions regarding this email, so I am trying to give a short answer here - as a short summary from the other threads...

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

easiest way to get around this "issue" will be updating the SDK to a newer version (after mid of 2022)

there will be coming up more details on this retirement in the next few weeks => here: https://learn.microsoft.com/en-us/rest/api/sql/retirement

You could use this query to find out more on your usage:

HttpIncomingRequests  
| where TIMESTAMP > ago(1d)  
| where targetResourceProvider == 'MICROSOFT.SQL'  
| where subscriptionId == 'xxxxxxxxxxxx'  
| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"  

and regarding your question... you don't have to update your Azure SQL database... it is all about the SDK which is used in application which are connecting to the database.

Answer 2

hello @Bjoern Peters
Kindly please help us where to execute this query
HttpIncomingRequests | where TIMESTAMP > ago(1d) | where targetResourceProvider == 'MICROSOFT.SQL' | where subscriptionId == 'xxxxxxxxxxxx' | where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"