Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025? - Stack Overflow

admin管理员组

文章数量:1417093

Getting email that Azure SQL Database 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.

I am trying to get the SQL Servers on the older version by the following

I open Azure Resource Graph Explorer and run the following:

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

But I get the error:

Failed to resolve column or scalar expression named 'TIMESTAMP' (Code:Operator_FailedToResolveEntity)
Filter expression should be Boolean (Code:Default)

How can I find which servers are using the older API version and update them, can I do it from the Azure portal?

Also what for example are the templates, tools, scripts, or programs, that also need to be upgraded?

Getting email that Azure SQL Database 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.

I am trying to get the SQL Servers on the older version by the following

I open Azure Resource Graph Explorer and run the following:

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

But I get the error:

Failed to resolve column or scalar expression named 'TIMESTAMP' (Code:Operator_FailedToResolveEntity)
Filter expression should be Boolean (Code:Default)

How can I find which servers are using the older API version and update them, can I do it from the Azure portal?

Also what for example are the templates, tools, scripts, or programs, that also need to be upgraded?

• azure
• azure-sql-database
• azure-resource-graph

Share Improve this question Follow edited Feb 3 at 5:43 marc_s 757k184184 gold badges1.4k1.4k silver badges1.5k1.5k bronze badges asked Feb 2 at 23:52 Wendy Wendy 2377 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

How can i find which servers are using the older api version and update them, can i do it from portal?

You can get it from Azure Resource Graph Explorer.

Resources
| where type =~ 'microsoft.sql/servers/databases'
| where apiVersion contains '2014-04-01'

Alternatively, you can also use az cli:

az graph query -q "Resources | where type =~ 'microsoft.sql/servers/databases' | where apiVersion contains '2014-04-01'"

It comes up empty for me but works if I change the api version.

Source: https://learn.microsoft/en-us/azure/governance/resource-graph/samples/advanced?tabs=azure-cli

Also what for example are the templates, tools, scripts, or programs, that also need to be upgraded?

This one has been answered by Azure Support here. I'll paste the response below.

Consider the following restAPI example to Create or Update a database: https://learn.microsoft/en-us/rest/api/sql/databases/create-or-update If you look a the top left had corner on this page you can see a drop down list with the following versions:

2023-05-01-preview
2021-11-01
2014-04-01

Selecting each one will give you a modified version of the restAPI command to create or update database

Selecting "2014-04-01" will give you the below:

PUT https://management.azure/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=**2014-04-01**

Selecting "2021-11-01" will give you the below:

PUT https://management.azure/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=**2021-11-01**

Note the last part of both PUT statements have different versions. So the Alert from MS is saying that if your app or script developers have used the older (2014) API version, they need to upgrade this to the newer (2021) API version. Hope this adds some more context.

本文标签： Azure SQL Database 20140401 APIs will be retired on 31 October 2025Stack Overflow