Azure SQL Database 2014-04-01 APIs will be retired

Shane Van Niekerk 81

Hello,

I would like to know where to go to see if the Azure SQL Database is using 2014-04-01 APIs.

Please let me know if you need any more info.

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2022-11-02T14:00:15.773+00:00

Hi, @Shane Van Niekerk We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

2 answers

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2022-11-01T15:35:49.493+00:00
Hi @Shane Van Niekerk Welcome to the Microsoft Q&A platform, thanks for posting the question
As I understand you want to know where to check if the Azure SQL Database is using 2014-04-01 APIs
There are two ways you can follow:

You need to upgrade to the latest clients versions (.NET SDK, PowerShell, CLI, python SDK, etc) before Oct 2025

If you are directly using API calls, you need to check your codebase or script about the SQL API usage before Oct 2025
Apparently, all you have to do is update the API version of your code. Azure SQL Database REST API 2014-04-01 Retirement Notice | Microsoft Learn
we are still working to update the retirement doc to list all the client's version which needs to be replaced.

Please let me know if you are looking for any additional information.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.
Please sign in to rate this answer.

2 people found this answer helpful.
Janne Kujanpää 181 Reputation points

2022-11-01T15:48:54.25+00:00

Is there any simple and fast way to do a query on activity log to see some details of the requests that caused the email to be sent?

E.g. when the the query happened and what is the user-agent of the client and who did the query-

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2022-11-01T16:39:22.743+00:00

@Janne Kujanpää maybe you could try to query ARM prod kusto table and these kusto queries can be executed by our internal team by raising a support case.

We will publish the updated retirement document soon with more details.

I have updated this comment.

Regards
Geetha

Jennifer Perkins 1 Reputation point

2022-11-01T16:43:53.997+00:00

Which version of .Net SDK is safe relative to this change?

Dan Guzman 9,211 Reputation points

2022-11-01T16:47:49.6+00:00

@Janne Kujanpää , I don't believe the email was triggered by activity. Rather, it's a general notification to existing SQL Database users to transition the new APIs by October 2025.

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2022-11-01T17:23:45.68+00:00

@Jennifer Perkins for current status: any version which is released after mid-2022; the newer the better.
we will announce the detailed SDK version retirement notice soon.

Regards
Geetha

Manikanta Macharla 1 Reputation point

2022-11-02T19:56:26.833+00:00

could you let me know the table and what has to be enabled to view that table in the LAW. TIA.

David K 1 Reputation point

2022-11-07T19:05:12.71+00:00

Which table does the KQL query need to be run against?

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2022-11-08T13:39:01.03+00:00

@Janne Kujanpää maybe you could try to query ARM prod kusto table and these kusto queries can be executed by our internal team by raising a support case.

We will publish the updated retirement document soon with more details.
I have updated this comment.

Regards
Geetha

alonisoft 0 Reputation points

2023-12-04T13:49:17.81+00:00

Is the .NET SDK also referring to the entity framework version we should upgrade ?
Sign in to comment
Kuttikrishnan P 5 Reputation points

2024-01-09T07:16:46.45+00:00

@GeethaThatipatri-MSFT

For our project we are using SQL Azure Database

Version : “Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 2 2023 01:40:17 Copyright (C) 2022 Microsoft Corporation”

Currently we have some Azure App services and Function apps which are connected to this DB .

In that , to connect to this DB we were using Entity Framework and ADO.net. To prepare for this retirement , please let me know what changes we need to make in our existing codebase or DB side.
Please sign in to rate this answer.
GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2024-01-10T13:33:09.7766667+00:00

@Kuttikrishnan P Could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details,

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regads

Geetha

Kuttikrishnan P 5 Reputation points

2024-02-05T05:05:24.2266667+00:00

@GeethaThatipatri-MSFT , Thanks for your comment. I have sent multiple email and waiting for the response from your team. Regards, Kutti

Kuttikrishnan P 0 Reputation points

2024-02-13T08:34:50.15+00:00

@GeethaThatipatri-MSFT , It will be great if you are able to help me on this. As per your previous comment, I have already sent an email and follow-up email.

Kuttikrishnan P 0 Reputation points

2024-03-27T03:56:41.1733333+00:00

@GeethaThatipatri-MSFT , It will be great if you are able to help me on this. Also please let me know if you need any other details from me.
Sign in to comment