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

Question

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

SIREESHA KETHINEDI 0

Hello All, I received an email from MS Azure stipulating that I need to update my Azure SQL Server API's to a newer version. Here is what was stated in the email:

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.

I require assistance in determining the necessary actions for updating. I have reviewed the documentation provided by Azure, but I found it challenging to comprehend.

3 answers

Your answer

Answer 1

Adding an example to for some more clarity on what is being asked by MS.

Consider the following restAPI example to Create or Update a database: https://learn.microsoft.com/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.com/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.com/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.

David B 20 Reputation points

2024-09-10T03:21:57.3733333+00:00

Thank you for the clarification but I still don't understand. Forgive me I know SQL Server but I do not normally work with Azure. I manage SQL databases for our clients but this is the only one that is in Azure, the rest are in regular SQL Server. I don't know what you mean by "restAPI" or "PUT" statements. I do appreciate the answer. But it would be even more appreciated if someone can answer the original question assuming that the asker has absolutely no experience in Azure and can give just an easy set of steps that I can follow.

Answer 2

Oury Ba-MSFT 20,931 Microsoft Employee Moderator

@SIREESHA KETHINEDI
Thank you for reaching out for more clarification. Microsoft sent an alert email to all the customers who registered for Microsoft.SQL. 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 There is a separate thread created for this question where in queries are addressed together. See the following link Azure SQL Database REST API 2014-04-01 Retirement Notice https://learn.microsoft.com/en-us/answers/questions/1073330/retirement-notice-azure-sql-database-2014-04-01-ap Hope this helps Regards, Oury

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-01-26T21:14:52.5666667+00:00

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
David B 20 Reputation points

2024-09-10T03:17:59.6533333+00:00

Hi, I have the same problem. Unfortunately the answer is not helpful. All it does is re-state the original question. In my case, I know SQL Server but do not work in Azure so I don't understand what needs to be upgraded, how I will know what needs to be upgraded, or how to do the upgrading.
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2024-09-30T18:26:33.4466667+00:00

@David B

You don’t need to worry about the databases if you’re only connecting to them via connection strings for your websites.

The retirement notice is specifically about the API version used for managing and interacting with Azure SQL Database resources programmatically.

The notice is about updating any scripts, tools, or programs that might still be using the old API version to manage the databases

Answer 3

Christoph Bayer 0

Hello all,

the update is about the REST-API, not the SQL Server or Database.

If you don't use the REST-API (or do not know what it is) you needn't change anything.

If you used the REST-API Version 2014 in your own application or script, you have to check for breaking changes in your code.

Best regards

Christoph

Share via

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

3 answers

Your answer