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

James Birchall 51 Reputation points
2022-11-02T09:00:17.067+00:00

I have received the email suggesting that we use these APIs. We have an Azure SQL database that we access using .NET 4.8 linq to entities. The answers provided to two prior questions on this subject are vague at best and seem to not relate to us in the slightest.

Can you say how we use the APIs as I am the developer of the app and have never knowingly used the APIs. If they are used in the Azure dashboard interface, then I am not concerned as I very rarely make use of that except to make sure stuff is running OK.

The two prior questions that I mentioned above are as follows:
https://learn.microsoft.com/en-us/answers/questions/1070597/azure-sql-database-2014-04-01-apis-will-be-retired.html
https://learn.microsoft.com/answers/questions/1071276/azure-sql-database-2014-04-01-apis-will-be-retired-1.html

Regards
Jim Birchall

Azure SQL Database
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee
    2022-11-02T17:18:26.997+00:00

    Hi, @James Birchall Thanks for posting the question

    If you do not have an app directly using 2014-04-01 API and if you only have " an Azure SQL database that accesses using .NET 4.8 linq to entities." then you are fine with this retirement.
    keep up to the latest .NET SDK is enough.
    Microsoft sent alert email to all the customers who registered for Microsoft.SQL.

    you don't need to run any query unless you want to check any activity log on the email sent.

    Please let me know if you have any additional questions.

    Regards
    Geetha

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2022-11-02T12:33:59.097+00:00

    Hi @James Birchall

    As you already stated, those other questions which got answered.
    I will give a short answer here - as short notice 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"