Is Azure SQL Database 2014-04-01 API retirement affecting Microsoft.EntityFrameworkCore.SqlServer 1.1.1?

Question

We received an email saying Azure SQL Database 2014-04-01 APIs will be retired on 31 Oct 2025. We have programs using Microsoft.EntityFrameworkCore.SqlServer version 1.1.1 to access the Azure SQL database service. I would like to know whether we are affected by this retirement.

If yes, then we can upgrade to version 1.1.6 which is the last version of 1.1.x. Upgrading to 2.x or later versions is not an option for us. Then is 1.1.6 using the 2014-04-01 APIs ?

Answer 1

Edwin Chan Thank you for posting your question on Microsoft Q&A forum support.

If you are building your program to access the Azure SQL Database via EntityFrameworkCore then you are not affected. You don't have to update your Azure SQL database... it is all about the SDK which is used in application which are connecting to the database. Please ignore the email.

Customers who have registered for Microsoft.SQL will receive these notifications, even though they did not create the Azure SQL DB, they receive it due to the Microsft.SQL is registered for the subscription.

Regards,

Oury

Answer 2

Hi Edwin Chan,

You have been notified that the Azure SQL Database API version 2014-04-01 will be retired, and the target APIs are APIs for Azure SQL Database management operations, such as changing the pricing tier, adding firewall rules, etc., connecting to Azure SQL Database and Please be assured that the use of data acquisition and update will not be affected. This alert on the azure advisory refers to an update that is being done on the APIs from azure.

If you are currently using the Azure portal, Azure CLI, or Azure PowerShell to manage Azure SQL Database, you do not need to take any action.

If you are using the REST API to manage Azure SQL Database, please make sure that you do not specify [api-version=2014-04-01] as shown below in the URL of the API you are currently calling.

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

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

when you are using the REST API to manage your databases try to use this below link to change API version of the database, https://learn.microsoft.com/en-us/rest/api/sql/databases/get?view=rest-sql-2021-11-01&tabs=HTTP#code-try-0

The actualizations are still being made and the documentation will be updated soon to include all client versions that needs to be updated.

I request you to refer the below document for further reference,

Azure SQL Database REST API 2014-04-01 Retirement Notice | Microsoft Learn

Note: Microsoft has sent an alert email to all the customers who have registered for Microsoft.sql (maybe in the past or they are registered currently). 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.

To check the version, Go to Azure portal, search for Resource Graph Explorer and Run the below query.

 resources

| distinct type , apiVersion

| where isnotnull(apiVersion)

| order by type asc

I hope this information helps. If the issue still persists, please let us know here. We will respond with more details and try to help you.

If this answers your query, do click Accept Answer and Yes for was this answer helpful.