Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Operations for Azure SQL Databases

Updated: May 18, 2015

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.

*Create or Update Data Masking Policy

Creates or updates a data masking policy for an Azure SQL Database.

*Create or Update Data Masking Rule

Creates or updates a data masking rule for an Azure SQL Database.

Database Operation Status

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

*Delete Data Masking Rule

Deletes a data masking rule for an Azure SQL Database.

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 Data Masking Policy

Returns the details for an Azure SQL Database’s dynamic data masking policy.

*Get Data Masking Rule

Returns the details for an Azure SQL Database’s data masking rule.

*Get Data Masking Rules

Returns the details for all of the data masking rules for a specific Azure SQL Database.

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.

*This feature is currently available only as a preview. The content related to this feature is preliminary.

See Also

Show:
© 2015 Microsoft