Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

Question

We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 31 October 2025. See our documentation for a detailed list of all impacted APIs, as well as new stable APIs.

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

Answer 1

In my request to Microsoft support they said they were sending out these warnings to anyone using Microsoft.SQL in their subscription which is anyone using Azure SQL databases basically. They said that if we are using Azure SQL Database, the APIs will automatically be updated. Also. if we did not write any code or use any third party software that make calls to this REST API for SQL for managing the server, then we do not have anything to upgrade.

Quote from Microsoft support:
The retirement of the 2014 API will not affect any Azure PaaS or SaaS products that are kept up to date, as the API will be updated automatically. For any 3rd party or unmonitored items that may use the old 2014 API, they will need to be updated by this time to avoid incompatible calls being made to the target databases.

More information:
Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 - Microsoft Q&A

https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F1072210%2Fazure-sql-database-2014-04-01-apis-will-be-retired-2.html%3Fsort%3Doldest&data=05%7C01%7Ckevinhanson%40microsoft.com%7C0dab81a525a54584f7ae08dac36e8ac5%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638037176914377567%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5I%2B1zDmd4JaXf3oa6HVriC1DObYFjrKIgqAILaAfLj4%3D&reserved=0

Answer 2

@bamboo System.Data.SqlClient" is the data plane client (like ODBC, JDBC, etc.) for SQL Server. However, what we plan to retire is a specific version (2014-04-01) of Azure SQL Database Management Service (control plane) API. They are two different things. so this is not affected by this retirement

-Geetha

Answer 3

[Edited to update link from internal documentation to external]

To minimize service disruption, please upgrade to a newer stable version or discontinue using Azure SQL Database 2014-04-01 APIs.

If you have any additional queries regarding this retirement, please use the comments on this thread to ask your specific queries and we will try our best to answer those queries. Thank You!

Answer 4

I'm sorry but I just don't see how I can find out which version of this API is used in my Azure resources. Can you explain this?

Thanks,
Will de Haan

Answer 5

Please, could you clarify how can I detect if 2014-04-01 APIs are used on my Azure SQL instances?

I cannot find any log showing the current use of Azure REST APIs, i.e. calls to https://management.azure.com/... affecting my resources, in this case, Sql databases. Does a log exist? If yes, where is it?

In the portal, if I open an Azure Sql Server or Azure Sql Database instance, I can see Activity Log. I suppose these are related to call arriving on REST API. But no "version" field is available.

Thank you