Operations for Azure SQL Databases

 

Updated: October 5, 2016

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

These commands all use the classic deployment model. You should use the newer Resource Manager based REST API commands located here.

Many new features of SQL Database are only supported when you are using the Azure Resource Manager deployment model, The 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. For more information, see Azure Resource Manager vs. classic deployment: Understand deployment models and the state of your resources.

TopicDescription
Change Subscription for a Single Server (classic)Moves a specific Azure SQL Database server from one subscription to another.
Change Subscription for All Servers (classic)Moves all Azure SQL Database servers from one subscription to another.
Create Database (classic)Creates an Azure SQL Database.
Create Database Recovery Request (classic)Creates a request to recover a specific Azure SQL Database.
Create Database Restore Request (classic)Creates a request to restore a specific Azure SQL Database.
Create Firewall Rule (classic)Creates a firewall rule for an Azure SQL Database server.
Create Server (classic)Creates an Azure SQL Database server.
Database Operation Status (classic)Returns the status of an operation on one or more Azure SQL Databases on a specific server.
Delete Database (classic)Deletes an Azure SQL Database.
Delete Firewall Rule (classic)Deletes an Azure SQL Database server firewall rule.
Delete Server (classic)Deletes an Azure SQL Database server.
Export Database (classic)Saves an Azure SQL Database as a BACPAC file into blob storage.
Get Database (classic)Gets details for an Azure SQL Database.
Get Database Copy (classic)Gets details for an Azure SQL Database copy.
Get Database Event Logs (classic)Gets the event logs for an Azure SQL Database.
Get Database Restore Request (classic)Gets a specific Azure SQL Database restore request.
Get Firewall Rule (classic)Gets details for a specific Azure SQL Database server firewall rule.
Get Import Export Database Status (classic)Returns the status of an Import/Export operation on an Azure SQL Database.
Get Quota (classic)Gets details for a specific Azure SQL Database server quota.
Get Recoverable Database (classic)Gets details for a specific recoverable Azure SQL Database.
Get Restorable Dropped Database (classic)Gets details for a specific restorable dropped Azure SQL Database.
Get Server Event Logs (classic)Gets the event logs for an Azure SQL Database server.
Get Service Level Objective (classic)Gets a specific service level objective for an Azure SQL Database server.
Get Service Objective Dimension Setting (classic)Gets a specific service objective dimension setting for an Azure SQL Database server.
Get Subscription Metadata (classic)Gets metadata details for a specific subscription.
Import Database (classic)Imports a database BACPAC file into an Azure SQL Database.
List Database Copies (classic)Returns a list of available copies of a specific Azure SQL Database.
List Databases (classic)Returns a list of Azure SQL Databases on a specific Azure SQL Database server.
List Firewall Rules (classic)Returns a list of firewall rules for a specific Azure SQL Database server.
List Quotas (classic)Returns a list of quotas for a specific Azure SQL Database server.
List Recoverable Databases (classic)Returns a list of recoverable databases for a specific Azure SQL Database server.
List Restorable Dropped Databases (classic)Returns a list of restorable dropped databases for a specific Azure SQL Database server.
List Server Database Restore Requests (classic)Returns a list of database restore requests for a specific Azure SQL Database server.
List Servers (classic)Returns a list of Azure SQL Database servers for a specific subscription.
List Service Level Objectives (classic)Returns a list of service level objectives for a specific Azure SQL Database server.
List Service Objective Dimension Settings (classic)Returns a list of service objective dimension settings for a specific Azure SQL Database server.
Set Firewall Rule (classic)Updates a firewall rule for a specific Azure SQL Database server.
Set Server Administrator Password (classic)Resets the administrator password for an Azure SQL Database server.
Start Database Copy (classic)Starts a one-time copy or a continuous copy of a specific Azure SQL Database.
Stop Database Copy (classic)Stops a running Azure SQL Database copy operation.
Update Database (classic)Updates details for an Azure SQL Database.
Update Database Copy (classic)Updates details for an Azure SQL Database copy.

Azure SQL Database REST API Reference

Show: