Operations for Azure SQL Databases
THIS TOPIC APPLIES TO: .jpeg "no")
SQL Server .jpeg "yes")
Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
Important
The recommended REST commands to work with SQL Database are the Resource Manager based Azure SQL Database REST API. While there is no change to SQL Database, be aware that the classic deployment model commands in this section are scheduled for deprecation on December 1, 2019. The following table provides links to the commands you should use as you transition from the older commands to the new.
Many new features of SQL Database are only supported when you are using the Azure Resource Manager deployment model, The classic REST API commands in this section DO NOT use the Azure Resource Manager deployment model, they use the older classic deployment model and are supported for backward compatibility only.
The Resource Manager deployment model provides several benefits, for example:
- The Resource Manager deployment model uses Azure Active Directory (AAD), whereas the classic deployment model uses certificate authorization.
- Resource Manager responses are JSON, as opposed to classic deployment responses that are XML.
For detailed information, see Azure Resource Manager vs. classic deployment: Understand deployment models and the state of your resources.
In this section
| Classic command | Azure Resource Manager command | Description |
|---|---|---|
| Change Subscription for a Single Server (classic) | Move Resources (Resources) | Moves a specific Azure SQL Database server from one subscription to another. |
| Change Subscription for All Servers (classic) | Move Resources (Resources) | Moves all Azure SQL Database servers from one subscription to another. |
| Create Database (classic) | Create or Update Database (Databases) | Creates an Azure SQL Database. |
| Create Database Recovery Request (classic) | Create or Update Database (Databases) | Creates a request to recover a specific Azure SQL Database. |
| Create Database Restore Request (classic) | Create or Update Database (Databases) | Creates a request to restore a specific Azure SQL Database. |
| Create Firewall Rule (classic) | Create or Update (Firewall Rules) | Creates a firewall rule for an Azure SQL Database server. |
| Create Server (classic) | Create or Update (Servers) | Creates an Azure SQL Database server. |
| Database Operation Status (classic) | List by Database (Database Operations) | Returns the status of an operation on one or more Azure SQL Databases on a specific server. |
| Delete Database (classic) | Delete (Databases) | Deletes an Azure SQL Database. |
| Delete Firewall Rule (classic) | Delete (Firewall Rules) | Deletes an Azure SQL Database server firewall rule. |
| Delete Server (classic) | Delete (Servers) | Deletes an Azure SQL Database server. |
| Export Database (classic) | Export (Databases) | Saves an Azure SQL Database as a BACPAC file into blob storage. |
| Get Database (classic) | Get (Databases) | Gets details for an Azure SQL Database. |
| Get Database Copy (classic) | Get (Replication Links) | Gets details for an Azure SQL Database copy. |
| Get Database Event Logs (classic) | List (Activity Logs) | Gets the event logs for an Azure SQL Database. |
| Get Database Restore Request (classic) | List by Database (Database Operations) | Gets a specific Azure SQL Database restore request. |
| Get Firewall Rule (classic) | Get (Firewall Rules) | Gets details for a specific Azure SQL Database server firewall rule. |
| Get Import Export Database Status (classic) | List (Operations) | Returns the status of an Import/Export operation on an Azure SQL Database. |
| Get Quota (classic) | List (Operations) | Gets details for a specific Azure SQL Database server quota. |
| Get Recoverable Database (classic) | Get (Recoverable Databases) | Gets details for a specific recoverable Azure SQL Database. |
| Get Restorable Dropped Database (classic) | Get (Restorable Dropped Databases) | Gets details for a specific restorable dropped Azure SQL Database. |
| Get Server Event Logs (classic) | List (Activity Logs) | Gets the event logs for an Azure SQL Database server. |
| Get Service Level Objective (classic) | List by Location (Capabilities) | Gets a specific service level objective for an Azure SQL Database server. |
| Get Service Objective Dimension Setting (classic) | List by Location (Capabilities) | Gets a specific service objective dimension setting for an Azure SQL Database server. |
| Get Subscription Metadata (classic) | List by Location (Subscription Usages) | Gets metadata details for a specific subscription. |
| Import Database (classic) | Import (Databases) | Imports a database BACPAC file into an Azure SQL Database. |
| List Database Copies (classic) | List by Database (Replication Links) | Returns a list of available copies of a specific Azure SQL Database. |
| List Databases (classic) | List by Server (Databases) | Returns a list of Azure SQL Databases on a specific Azure SQL Database server. |
| List Firewall Rules (classic) | List by Server (Firewall Rules) | Returns a list of firewall rules for a specific Azure SQL Database server. |
| List Quotas (classic) | List (Operations) | Returns a list of quotas for a specific Azure SQL Database server. |
| List Recoverable Databases (classic) | List by Server (Recoverable Databases) | Returns a list of recoverable databases for a specific Azure SQL Database server. |
| List Restorable Dropped Databases (classic) | List by Server (Restorable Dropped Databases) | Returns a list of restorable dropped databases for a specific Azure SQL Database server. |
| List Server Database Restore Requests (classic) | Get (Databases) | Returns a list of database restore requests for a specific Azure SQL Database server. |
| List Servers (classic) | List (Servers) | Returns a list of Azure SQL Database servers for a specific subscription. |
| List Service Level Objectives (classic) | List by Location (Capabilities) | Returns a list of service level objectives for a specific Azure SQL Database server. |
| List Service Objective Dimension Settings (classic) | List by Location (Capabilities) | Returns a list of service objective dimension settings for a specific Azure SQL Database server. |
| Set Firewall Rule (classic) | Create or Update (Firewall Rules) | Updates a firewall rule for a specific Azure SQL Database server. |
| Set Server Administrator Password (classic) | Update (Servers) | Resets the administrator password for an Azure SQL Database server. |
| Start Database Copy (classic) | Create or Update (Databases) | Starts a one-time copy or a continuous copy of a specific Azure SQL Database. |
| Stop Database Copy (classic) | Update (Databases) | Stops a running Azure SQL Database copy operation. |
| Update Database (classic) | Create or Update (Databases) | Updates details for an Azure SQL Database. |
| Update Database Copy (classic) | Update (Databases) | Updates details for an Azure SQL Database copy. |