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

Question

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

Bob Fischer 71

I use two methods for addressing Azure SQL data:

Sync local and Azure databases using the Azure Sync methods administered on the portal
Direct access from a desktop app to Azure using VB.NET 2022 and ADO

I assume Item 1 must not be a problem. Would #2, ADO access, be covered by this announcement?

Thanks.

GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee

2022-11-04T14:10:13.63+00:00

@Bob Fischer Thanks for posting your question in the Microsoft Q&A forum.
Can you please provide more information on your ask,

Regards
Geetha
Bob Fischer 71 Reputation points

2022-11-05T12:21:07.443+00:00

I will be making a desktop app for a new customer using direct access to Azure SQL Database via ADO. NET in VB.NET 2022, and SSMS for maintenance. Do these tools need to be updated to suit the API change? If so I also need to update several legacy apps. Thanks.

GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee

2022-11-04T14:10:13.63+00:00

@Bob Fischer Thanks for posting your question in the Microsoft Q&A forum.
Can you please provide more information on your ask,

Regards
Geetha
Bob Fischer 71 Reputation points

2022-11-05T12:21:07.443+00:00

I will be making a desktop app for a new customer using direct access to Azure SQL Database via ADO. NET in VB.NET 2022, and SSMS for maintenance. Do these tools need to be updated to suit the API change? If so I also need to update several legacy apps. Thanks.

Answer 1

GeethaThatipatri-MSFT 19,276 Microsoft Employee

@Bob Fischer

from ADO itself to Azure SQL DB should be fine 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 ADO. NET in VB.NET 2022 then you are fine with this retirement.

Not sure about this customized setup. If you are using the latest .NET SDK, there will be no problem.

Please check this document for more information
we are updating the retirement doc to list all the client's version which needs to be replaced.

Regards
Geetha

GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee

2022-11-07T15:50:37.357+00:00

@Bob Fischer Did you have the chance to check the above reply, please let us know if you have any additional questions or if you find the above reply useful. If yes, do click on the 'Mark as answer'in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha
GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee

2022-11-07T16:30:10.177+00:00

Thanks, @Bob Fischer for your feedback could you please mark this answer as accepted.

Regards
Geetha

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

0 additional answers

Activity