Share via

Azure SQL Database REST API 2014-04-01 Retirement Notice

  • Article

We’re constantly making updates to Azure SQL APIs to ensure optimal security and performance. Therefore, we’ll be retiring following 2014-04-01 Azure SQL DB APIs on 31 October 2025. To minimize service disruption, please upgrade to a newer version or remove the usage of these older version Azure SQL DB APIs.

Stable API Mappings From 2014-04-01 to 2021-11-01

Old 2014-04-01 stable APIs New 2021-11-01 stable APIs
Capabilities Capabilities
Data Masking Policies Data Masking Policies
Data Masking Rules Data Masking Rules
Database Advisors Database Advisors
Database Connection Policies Deprecated*
Database Table Auditing Policies Database Blob Auditing Policies
Database Threat Detection Policies Database Advanced Threat Protection Settings
Database Usages Database Usages
Databases Databases
Disaster Recovery Configurations Failover Groups
Elastic Pool Activities Deprecated*
Elastic Pool Database Activities Deprecated*
Elastic Pools Elastic Pools
Extensions Database Extensions
Firewall Rules Firewall Rules
Geo Backup Policies Geo Backup Policies
Operations Operations
Queries Deprecated*
Query Statistics Deprecated*
Query Texts Deprecated*
Recommended Elastic Pools Deprecated*
Recoverable Databases Recoverable Databases
Replication Links Replication Links
Restorable Dropped Databases Restorable Dropped Managed Databases
Restore Points Restore Points
Server Advisors Server Advisors
Server Azure AD Administrators Server Azure AD Administrators
Server Connection Policies Server Connection Policies
Server Table Auditing Policies Server Blob Auditing Policies
Server Usages Server Usages
Servers Name Availability Servers Name Availability
Servers Servers
Service Objectives Capabilities
Service Tier Advisors Deprecated*
Transparent Data Encryption Activities Transparent Data Encryptions
Transparent Data Encryption Configurations Transparent Data Encryptions
Transparent Data Encryptions Transparent Data Encryptions

* APIs marked as deprecated with no newer/stable versions, are permanently discontinued from the service. Please reevaluate your usage scenarios for these APIs.

Latest Stable Version of Azure SQL Database REST API

2021-11-01 API Operation Group Description
Backup Short Term Retention Policies Create, get, update, list a database's short term retention policy.
Capabilities Get the subscription capabilities available for the specified location.
Data Masking Policies Creates, updates, get a database data masking policy.
Data Masking Rules Creates, updates, list a database data masking rule.
Data Warehouse User Activities Get and list the user activities of a data warehouse which includes running and suspended queries.
Database Advanced Threat Protection Settings Create, get, update, list a database's Advanced Threat Protection state
Database Advisors Get and list database advisors.
Database Automatic Tuning Get and update a database's automatic tuning.
Database Blob Auditing Policies Create, get, update, list a database's blob auditing policy.
Database Columns Get and list database columns.
Database Extensions Perform a database extension operation, like polybase import.
Database Operations Get a list of operations performed on the database or cancels the asynchronous operation on the database.
Database Recommended Actions Get and update a database recommended action.
Database Schemas Get and list database schemas.
Database Security Alert Policies Create, get, update, list a database's security alert policy.
Database Tables Get and list database tables.
Database Usages Get database usages.
Database Vulnerability Assessment Rule Baselines Create, get, update, list, delete the database's vulnerability assessment rule baseline.
Database Vulnerability Assessment Scans Get, list, execute, export the vulnerability assessment scans of a database.
Database Vulnerability Assessments Create, get, update, list, delete the database's vulnerability assessment.
Databases Create, get, update, list, delete, import, export, rename, pause, resume, upgrade SQL databases.
Deleted Servers Get, list, recover the deleted servers.
Distributed Availability Groups Creates, updates, list, get, delete a distributed availability group between Sql On-Prem and Sql Managed Instance.
Elastic Pool Operations Gets a list of operations performed on the elastic pool or cancels the asynchronous operation on the elastic pool.
Elastic Pools Create, get, update, delete, failover the elastic pools.
Encryption Protectors Get, update, list, revalidate the existing encryption protectors.
Endpoint Certificates Get and list the certificates used on endpoints on the target instance.
Extended Database Blob Auditing Policies Create, get, update, list an extended database's blob auditing policy.
Extended Server Blob Auditing Policies Create, get, update, list an extended server's blob auditing policy.
Failover Groups Create, get, update, list, delete, and failover a failover group.
Firewall Rules Create, get, update, delete, list firewall rules.
Geo Backup Policies Create, update, get, list a database default Geo backup policy.
Instance Failover Groups Create, get, update, list, delete, and failover an instance failover group.
Instance Pools Create, get, update, list, delete the instance pools.
IP V6 Firewall Rules Creates, updates, get, list, delete an IPv6 firewall rule.
Job Agents Create, get, update, list, delete the job agents.
Job Credentials Create, get, update, list, delete the job credentials.
Job Executions Create, get, update, list, cancel the job executions.
Job Step Executions Get and list the step executions of a job execution.
Job Steps Create, get, update, list, delete job steps for a job's current version.
Job Target Executions Get or list the target executions of a job step execution.
Job Target Groups Create, get, update, list, delete the job target groups.
Job Versions Get or list job versions.
Jobs Create, get, update, list, delete jobs.
Ledger Digest Uploads Create, get, update, list the ledger digest upload configuration for a database.
Long Term Retention Backups Create, get, update, list, delete a long term retention backup.
Long Term Retention Managed Instance Backups Create, get, update, list, delete a long term retention backup for a managed database.
Long Term Retention Policies Get, list, set a database's long term retention policy.
Maintenance Window Options Gets a list of available maintenance windows.
Maintenance Windows Get or set maintenance windows settings for a database.
Managed Backup Short Term Retention Policies Create, get, update, list a managed database's short term retention policy.
Managed Database Columns Get or list managed database columns.
Managed Database Queries Get query or query execution statistics by query id of a managed database.
Managed Database Recommended Sensitivity Labels Update recommended sensitivity labels states of a given database using an operations batch.
Managed Database Restore Details Get managed database restore details.
Managed Database Schemas Get or list managed database schemas.
Managed Database Security Alert Policies Create, get, update, list the managed database security alert policies.
Managed Database Security Events Get a list of managed database security events.
Managed Database Sensitivity Labels Create, get, update, list the sensitivity labels of a given database. Or enable or disable sensitivity recommendations on a given column.
Managed Database Tables Get or list managed database tables.
Managed Database Transparent Data Encryption Create, get, update, list a managed database's transparent data encryption.
Managed Database Vulnerability Assessment Rule Baselines Create, get, update, list a managed database's vulnerability assessment rule baseline.
Managed Database Vulnerability Assessment Scans Get, list, execute, export a managed database's vulnerability assessment scans.
Managed Database Vulnerability Assessments Create, get, update, list, delete a managed database's vulnerability assessments.
Managed Databases Create, get, update, list, delete, restore the managed databases.
Managed Instance Administrators Create, get, update, list, delete managed instance administrators.
Managed Instance Azure AD Only Authentications Get, set, list, delete the existing server Active Directory only authentication properties.
Managed Instance Encryption Protectors Get, update, list, revalidate the existing encryption protectors of a managed instance.
Managed Instance Keys Create, get, update, list, delete the managed instance keys.
Managed Instance Long Term Retention Policies Create, get, list, update the managed instance's long term retention policies.
Managed Instance Operations Get, list, cancel the operations performed on the managed instance.
Managed Instance Private Endpoint Connections Create, get, list, update, delete the private endpoint connections on a managed instance.
Managed Instance Private Link Resources Get or list the private link resources on the managed instance.
Managed Instance Tde Certificates Create a Transparent Data Encryption certificate for a given managed instance.
Managed Instance Vulnerability Assessments Create, get, list, update, delete the managed instance's vulnerability assessment policies.
Managed Instances Create, get, update, list, delete, failover the managed instances.
Managed Restorable Dropped Database Backup Short Term Retention Policies Create, get, update, list the managed restorable dropped database's short term retention policies.
Managed Server Dns Aliases Create, get, list, acquire a managed server DNS alias.
Managed Server Security Alert Policies Create, get, list, update the managed server's security alert policies.
Operations List all of the available SQL Database REST API operations.
Outbound Firewall Rules Create, get, update, list, delete the outbound firewall rules.
Private Endpoint Connections Create, get, update, list, delete the private endpoint connections on a server.
Private Link Resources Get or list the private link resources for SQL server.
Recommended Sensitivity Labels Update recommended sensitivity labels states of a given database using an operations batch.
Recoverable Databases Get a recoverable database, or list all recoverable databases for a server.
Recoverable Managed Databases Get or list recoverable managed databases.
Replication Links Get, list, delete, and failover replication links.
Restorable Dropped Databases Get or list restorable dropped databases.
Restorable Dropped Managed Databases Get or list restorable dropped managed databases.
Restore Points Create, get, update, list, delete database restore points.
Sensitivity Labels Create, get, update, list the sensitivity labels of a given database. Or enable or disable sensitivity recommendations on a given column.
Server Advanced Threat Protection Settings Create, get, update, list the server's Advanced Threat Protection states.
Server Advisors Get, list, update server advisors.
Server Automatic Tuning Get or update automatic tuning options on server.
Server Azure AD Administrators Create, get, list, update, delete Azure Active Directory administrators in a server.
Server Azure AD Only Authentications Create, get, list, update, delete server Active Directory only authentication property.
Server Blob Auditing Policies Create, get, update, list an extended server or database's blob auditing policy.
Server Connection Policies Create, update, get, list a server connection policy.
Server DevOps Audit Settings Create, get, list, update DevOps audit settings of a server.
Server Dns Aliases Create, get, list, acquire or delete a server DNS alias.
Server Keys Create, get, list, update, delete server keys.
Server Operations Get a list of operations performed on the server.
Server Security Alert Policies Create, get, list, update a server's security alert policies.
Server Trust Certificates Create, get, list, update, delete server trust certificates.
Server Trust Groups Create, get, list, update, delete server trust groups.
Server Usages Get server usages.
Server Vulnerability Assessments Create, get, list, update, delete the server vulnerability assessment policies.
Servers Create, get, update, list, delete information about an Azure SQL server. and determine whether a resource can be created with the specified name.
Sql Agent Get or set the sql agent configuration to instance.
Subscription Usages Get or list the subscription usage metrics.
Sync Agents Create, get, list, update, delete the sync agents. Or generate a sync agent key.
Sync Groups Create, get, list, update, delete the sync groups. Or refreshes a hub database schema.
Sync Members Create, get, list, update, delete the sync members.
Tde Certificates Create a Transparent Data Encryption certificate for a given server.
Time Zones Get or list the managed instance time zones.
Transparent Data Encryptions Create, get, list, update a logical database's transparent data encryption configurations.
Usages Gets all instance pool usage metrics.
Virtual Clusters Create, get, list, update, delete the virtual clusters.
Virtual Network Rules Create, get, list, update, delete the virtual network rules.
Workload Classifiers Create, get, list, update, delete the workload classifiers.
Workload Groups Create, get, list, update, delete the workload groups.

See Also