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

GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
2022-11-02T22:58:09.407+00:00

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

Azure SQL Database
{count} votes

6 answers

Sort by: Most helpful
  1. Rebecca Allen 66 Reputation points
    2022-11-15T19:44:30.85+00:00

    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

    6 people found this answer helpful.

  2. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
    2022-12-26T10:12:38.25+00:00

    @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

    1 person found this answer helpful.
    0 comments No comments

  3. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
    2022-11-02T22:59:24.563+00:00

    [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!


  4. Will de Haan 1 Reputation point
    2022-11-09T07:57:54.727+00:00

    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


  5. fhtino 136 Reputation points
    2022-12-03T06:20:40.22+00:00

    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

    0 comments No comments