Azure SQL Database

This topic displays help topics for the Azure SQL Database Cmdlets.

Azure PowerShell is a command-line shell and scripting language designed to help information technology (IT) professionals automate system administration tasks. To install the latest Azure PowerShell version and associate it with your Azure subscription, see How to install and configure Azure PowerShell. For more information about Azure Resource Manager cmdlets, see Using Azure PowerShell with Azure Resource Manager.

Before you run cmdlets in Azure Resource Manager, switch to Azure Resource Manager mode. To switch to this mode, type the following command:

Switch-AzureMode AzureResourceManager

Warning

The Switch-AzureMode cmdlet is deprecated. For more information, see Deprecation of Switch AzureMode in Azure PowerShell (https://github.com/Azure/azure-powershell/wiki/Deprecation-of-Switch-AzureMode-in-Azure-PowerShell).

This deprecation is a breaking change. You may need to revise scripts that operate in Azure Resource Manager.

This module includes preliminary documentation that is subject to change. Blank topics are included as placeholders.

The following table contains links to the topics for the Azure SQL Database Cmdlets:

Name Description

Get-AzureSqlDatabase

Gets one or more Azure SQL databases.

Get-AzureSqlDatabaseAuditingPolicy

Gets the auditing policy of an Azure SQL database.

Get-AzureSqlDatabaseDataMaskingPolicy

Gets the data masking policy for an Azure SQL database.

Get-AzureSqlDatabaseDataMaskingRule

Gets the data masking rules from an Azure SQL database.

Get-AzureSqlDatabaseSecureConnectionPolicy

Gets the secure connection policy of an Azure SQL database.

Get-AzureSqlDatabaseTransparentDataEncryption

Gets the TPE state for an Azure SQL database.

Get-AzureSqlDatabaseTransparentDataEncryptionActivity

Gets the progress of a TDE scan of an Azure SQL database.

Get-AzureSqlElasticPool

Gets elastic pools and their property values in an Azure SQL Database.

Get-AzureSqlElasticPoolActivity

Gets the status of operations on an elastic pool.

Get-AzureSqlElasticPoolDatabase

Gets elastic databases in an elastic pool and their property values.

Get-AzureSqlElasticPoolRecommendation

Gets elastic pool recommendations.

Get-AzureSqlServer

Returns information about Azure SQL Database servers.

Get-AzureSqlServerAuditingPolicy

Gets the auditing policy of an Azure SQL server.

Get-AzureSqlServerFirewallRule

Gets firewall rules for an Azure SQL Database server.

Get-AzureSqlServerServiceObjective

Gets service objectives for an Azure SQL Database server.

Get-AzureSqlServerUpgrade

Gets the status of an Azure SQL Database server upgrade.

New-AzureSqlDatabase

Creates an Azure SQL database or an elastic database.

New-AzureSqlDatabaseDataMaskingRule

Creates a data masking rule for an Azure SQL database.

New-AzureSqlElasticPool

Creates an elastic database pool in Azure SQL Database.

New-AzureSqlServer

Creates an Azure SQL Database server.

New-AzureSqlServerFirewallRule

Creates a firewall rule for an Azure SQL Database server.

Remove-AzureSqlDatabase

Removes an Azure SQL database.

Remove-AzureSqlDatabaseAuditing

Removes auditing of an Azure SQL database.

Remove-AzureSqlDatabaseDataMaskingRule

Removes a data masking rule from an Azure SQL database.

Remove-AzureSqlElasticPool

Deletes an elastic database pool.

Remove-AzureSqlServer

Removes an Azure SQL Database server.

Remove-AzureSqlServerAuditing

Removes auditing of an Azure SQL server.

Remove-AzureSqlServerFirewallRule

Deletes a firewall rule from an Azure SQL Database server.

Resume-AzureSqlDatabase

Resumes an Azure SQL database.

Set-AzureSqlDatabase

Sets properties for an Azure SQL database, or moves an existing database into an elastic pool.

Set-AzureSqlDatabaseAuditingPolicy

Sets the auditing policy for an Azure SQL database.

Set-AzureSqlDatabaseDataMaskingPolicy

Sets data masking for an Azure SQL database.

Set-AzureSqlDatabaseDataMaskingRule

Sets the properties of a data masking rule in an Azure SQL database.

Set-AzureSqlDatabaseTransparentDataEncryption

Modifies TPE for an Azure SQL database.

Set-AzureSqlElasticPool

Modifies properties for an elastic database pool in Azure SQL Database.

Set-AzureSqlServer

Modifies properties of an Azure SQL Database server.

Set-AzureSqlServerAuditingPolicy

Changes the auditing policy of an Azure SQL server.

Set-AzureSqlServerFirewallRule

Modifies a firewall rule in Azure SQL Database server.

Start-AzureSqlServerUpgrade

Starts the upgrade of an Azure SQL Database server.

Stop-AzureSqlServerUpgrade

Stops the upgrade of an Azure SQL Database server.

Suspend-AzureSqlDatabase

Suspends an Azure SQL database.

Use-AzureSqlServerAuditingPolicy

Specifies that a database uses the auditing policy of its hosting server.

For more information about, or for the syntax of, any of the cmdlets, use the Get-Help<cmdlet name> cmdlet, where <cmdlet name> is the name of the cmdlet that you want to research. For more detailed information, you can run any of the following cmdlets:

Get-Help<cmdlet name>-Detailed
Get-Help<cmdlet name>-Examples
Get-Help<cmdlet name>-Full

See Also

Concepts

Azure Resource Manager Cmdlets