Azure SQL Database 2014-04-01 API retirement

Question

We have received notification for Azure SQL Database 2014-04-01 API will be retired soon. I ran a query and have some feedback on what items are affected but I do not know what needs to be done exactly. I see that APIs need to be replaced but how is that normally done? The documentation does not say explicitly what needs to be done, just that it needs to be updated. I need more details please.

Thank you,
Katherine Macika

Answer 1

Hi @ Macika, Katherine,
Thank you for reaching out to SQL forum.

To handle the retirement of the Azure SQL Database 2014-04-01 API, first use Azure Resource Graph Explorer to find which resources still use that old API version, then update your ARM templates, PowerShell scripts, or CLI commands to reference the latest supported API version listed in Microsoft’s documentation; this means replacing any "apiVersion": "2014-04-01" entries with newer ones, testing those changes in a safe environment to make sure deployments and operations still work, and completing all updates before the June 30, 2026 deadline to avoid service disruptions.

https://learn.microsoft.com/en-us/rest/api/sql/retirement

https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0?page=2#answers

Best Regards,

Lakshmi.