SALES: 1-800-867-1380

Operations for Azure SQL Databases

Updated: October 15, 2014

The Service Management API includes operations for managing Azure SQL Databases, Azure SQL Database servers, and Azure SQL Database server firewall rules.

 

Topic Description

Change Subscription (For a Single Server)

Moves a specific Azure SQL Database server from one subscription to another.

Change Subscription (For All Servers)

Moves all Azure SQL Database servers from one subscription to another.

Create Database

Creates an Azure SQL Database.

Create Database Recovery Request

Creates a request to recover a specific Azure SQL Database.

Create Database Restore Request

Creates a request to restore a specific Azure SQL Database.

Create Firewall Rule

Creates a firewall rule for an Azure SQL Database server.

Create Server

Creates an Azure SQL Database server.

Database Operation Status

Returns the status of an operation on one or more Azure SQL Databases on a specific server.

Delete Database

Deletes an Azure SQL Database.

Delete Firewall Rule

Deletes an Azure SQL Database server firewall rule.

Delete Server

Deletes an Azure SQL Database server.

Export Database

Saves an Azure SQL Database as a BACPAC file into blob storage.

Get Database

Gets details for an Azure SQL Database.

Get Database Copy

Gets details for an Azure SQL Database copy.

Get Database Event Logs

Gets the event logs for an Azure SQL Database.

Get Database Restore Request

Gets a specific Azure SQL Database restore request.

Get Firewall Rule

Gets details for a specific Azure SQL Database server firewall rule.

Get Import/Export Database Status

Returns the status of an Import/Export operation on an Azure SQL Database.

Get Quota

Gets details for a specific Azure SQL Database server quota.

Get Recoverable Database

Gets details for a specific recoverable Azure SQL Database.

Get Restorable Dropped Database

Gets details for a specific restorable dropped Azure SQL Database.

Get Server Event Logs

Gets the event logs for an Azure SQL Database server.

Get Service Level Objective

Gets a specific service level objective for an Azure SQL Database server.

Get Service Objective Dimension Setting

Gets a specific service objective dimension setting for an Azure SQL Database server.

Get Subscription Metadata

Gets metadata details for a specific subscription.

Import Database

Imports a database BACPAC file into an Azure SQL Database.

List Database Copies

Returns a list of available copies of a specific Azure SQL Database.

List Databases

Returns a list of Azure SQL Databases on a specific Azure SQL Database server.

List Firewall Rules

Returns a list of firewall rules for a specific Azure SQL Database server.

List Quotas

Returns a list of quotas for a specific Azure SQL Database server.

List Recoverable Databases

Returns a list of recoverable databases for a specific Azure SQL Database server.

List Restorable Dropped Databases

Returns a list of restorable dropped databases for a specific Azure SQL Database server.

List Server Database Restore Requests

Returns a list of database restore requests for a specific Azure SQL Database server.

List Servers

Returns a list of Azure SQL Database servers for a specific subscription.

List Service Level Objectives

Returns a list of service level objectives for a specific Azure SQL Database server.

List Service Objective Dimension Settings

Returns a list of service objective dimension settings for a specific Azure SQL Database server.

Set Firewall Rule

Updates a firewall rule for a specific Azure SQL Database server.

Set Server Administrator Password

Resets the administrator password for an Azure SQL Database server.

Start Database Copy

Starts a one-time copy or a continuous copy of a specific Azure SQL Database.

Stop Database Copy

Stops a running Azure SQL Database copy operation.

Update Database

Updates details for an Azure SQL Database.

Update Database Copy

Updates details for an Azure SQL Database copy.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft