AzureRM.Sql
This topic displays help topics for the Azure SQL Database Cmdlets.
SQL
| Add-Azure |
Adds one or more databases to an Azure SQL Database Failover Group. |
| Add-Azure |
Adds a Key Vault key to a SQL server. |
| Get-Azure |
Gets SQL Database capabilities for the current subscription. |
| Get-Azure |
Gets one or more databases. |
| Get-Azure |
Gets the status of moving elastic databases. |
| Get-Azure |
Gets one or more Advisors for an Azure SQL Database. |
| Get-Azure |
Gets the auditing policy of a database. |
| Get-Azure |
Gets a database long term retention policy. |
| Get-Azure |
Gets the data masking policy for a database. |
| Get-Azure |
Gets the data masking rules from a database. |
| Get-Azure |
Gets a database and its expanded property values. |
| Get-Azure |
Gets or lists Azure SQL Database Failover Groups. |
| Get-Azure |
Gets a geo-redundant backup of a database. |
| Get-Azure |
Gets a database geo backup policy. |
| Get-Azure |
Gets the details of an import or export of an Azure SQL Database. |
| Get-Azure |
Gets the recommended index operations for a server or database. |
| Get-Azure |
Gets one or more recommended actions for an Azure SQL Database Advisor. |
| Get-Azure |
Gets the geo-replication links between an Azure SQL Database and a resource group or SQL Server. |
| Get-Azure |
Retrieves the distinct restore points from which a SQL Data Warehouse can be restored. |
| Get-Azure |
Gets the secure connection policy for a database. |
| Get-Azure |
Gets the threat detection policy for a database. |
| Get-Azure |
Gets the TDE state for a database. |
| Get-Azure |
Gets the progress of a TDE scan of a database. |
| Get-Azure |
Gets pricing tier hints for a database. |
| Get-Azure |
Gets a deleted database that you can restore. |
| Get-Azure |
Gets elastic pools and their property values in an Azure SQL Database. |
| Get-Azure |
Gets the status of operations on an elastic pool. |
| Get-Azure |
Gets one or more Advisors for an Azure SQL Elastic Pool. |
| Get-Azure |
Gets elastic databases in an elastic pool and their property values. |
| Get-Azure |
Gets elastic pool recommendations. |
| Get-Azure |
Gets one or more recommended actions for an Azure SQL Elastic Pool Advisor. |
| Get-Azure |
Returns information about SQL Database servers. |
| Get-Azure |
Gets information about an Azure AD administrator for SQL Server. |
| Get-Azure |
Gets one or more Advisors for an Azure SQL Server. |
| Get-Azure |
Gets the auditing policy of a SQL server. |
| Get-Azure |
Gets a server long term retention vault. |
| Get-Azure |
Gets communication links for elastic database transactions between database servers. |
| Get-Azure |
Gets a database server system recovery configuration. |
| Get-Azure |
Gets activity for a database server system recovery configuration. |
| Get-Azure |
Gets firewall rules for a SQL Database server. |
| Get-Azure |
Gets a SQL server's Key Vault keys. |
| Get-Azure |
Gets one or more recommended actions for an Azure SQL Server Advisor. |
| Get-Azure |
Gets service objectives for an Azure SQL Database server. |
| Get-Azure |
Gets the threat detection policy for a server. |
| Get-Azure |
Gets the Transparent Data Encryption (TDE) protector |
| Get-Azure |
Gets the status of an Azure SQL Database server upgrade. |
| Get-Azure |
Gets pricing tier hints for upgrading an Azure SQL Database server. |
| Get-Azure |
Returns information about Azure SQL Sync Agents. |
| Get-Azure |
Returns information about SQL Server databases linked by a sync agent. |
| Get-Azure |
Returns information about Azure SQL Database Sync Groups. |
| Get-Azure |
Returns the logs of an Azure SQL Database Sync Group. |
| Get-Azure |
Returns information about Azure SQL Database Sync Members. |
| New-Azure |
Creates a database or an elastic database. |
| New-Azure |
Creates a copy of a SQL Database that uses the snapshot at the current time. |
| New-Azure |
Creates a data masking rule for a database. |
| New-Azure |
Exports an Azure SQL Database as a .bacpac file to a storage account. |
| New-Azure |
This command creates a new Azure SQL Database Failover Group. |
| New-Azure |
Imports a .bacpac file and create a new database on the server. |
| New-Azure |
Creates a secondary database for an existing database and starts data replication. |
| New-Azure |
Creates an elastic database pool for a SQL Database. |
| New-Azure |
Creates a SQL Database server. |
| New-Azure |
Creates a communication link for elastic database transactions between two SQL Database servers. |
| New-Azure |
Creates a database server system recovery configuration. |
| New-Azure |
Creates a firewall rule for a SQL Database server. |
| New-Azure |
Creates an Azure SQL Sync Agent. |
| New-Azure |
Creates an Azure SQL Sync Agent Key. |
| New-Azure |
Creates an Azure SQL Database Sync Group. |
| New-Azure |
Creates an Azure SQL Database Sync Member. |
| Remove-Azure |
Removes an Azure SQL database. |
| Remove-Azure |
Removes the auditing of a database. |
| Remove-Azure |
Removes a data masking rule from a database. |
| Remove-Azure |
Removes an Azure SQL Database Failover Group. |
| Remove-Azure |
Removes one or more databases from an Azure SQL Database Failover Group. |
| Remove-Azure |
Terminates data replication between a SQL Database and the specified secondary database. |
| Remove-Azure |
Removes the threat detection policy from a database. |
| Remove-Azure |
Deletes an elastic database pool. |
| Remove-Azure |
Removes an Azure SQL Database server. |
| Remove-Azure |
Removes an Azure AD administrator for SQL Server. |
| Remove-Azure |
Removes the auditing of a SQL server. |
| Remove-Azure |
Deletes a communication link for elastic database transactions between two servers. |
| Remove-Azure |
Removes a SQL database server system recovery configuration. |
| Remove-Azure |
Deletes a firewall rule from a SQL Database server. |
| Remove-Azure |
Removes a Key Vault key from a SQL server. |
| Remove-Azure |
Removes the threat detection policy from a server. |
| Remove-Azure |
Removes an Azure SQL Sync Agent. |
| Remove-Azure |
Removes an Azure SQL Database Sync Group. |
| Remove-Azure |
Removes an Azure SQL Database Sync Member. |
| Restore-Azure |
Restores a SQL database. |
| Resume-Azure |
Resumes a SQL Data Warehouse database. |
| Set-Azure |
Sets properties for a database, or moves an existing database into an elastic pool. |
| Set-Azure |
Modifies auto execute status of an Azure SQL Database Advisor. |
| Set-Azure |
Sets the auditing policy for a database. |
| Set-Azure |
Sets a server long term retention policy. |
| Set-Azure |
Sets data masking for a database. |
| Set-Azure |
Sets the properties of a data masking rule for a database. |
| Set-Azure |
Modifies the configuration of an Azure SQL Database Failover Group. |
| Set-Azure |
Sets a database geo backup policy. |
| Set-Azure |
Updates the state of an Azure SQL Database recommended action. |
| Set-Azure |
Switches a secondary database to be primary in order to initiate failover. |
| Set-Azure |
Sets a threat detection policy on a database. |
| Set-Azure |
Modifies TDE property for a database. |
| Set-Azure |
Modifies properties of an elastic database pool in a SQL Database. |
| Set-Azure |
Updates auto execute status of an Azure SQL Elastic Pool Advisor. |
| Set-Azure |
Updates the state of an Azure SQL Elastic Pool recommended action. |
| Set-Azure |
Modifies properties of a SQL Database server. |
| Set-Azure |
Provisions an Azure AD administrator for SQL Server. |
| Set-Azure |
Updates the auto execute status of an Azure SQL Server Advisor. |
| Set-Azure |
Changes the auditing policy of a SQL Database server. |
| Set-Azure |
Sets a server long term retention vault. |
| Set-Azure |
Modifies a database server recovery configuration. |
| Set-Azure |
Modifies a firewall rule in Azure SQL Database server. |
| Set-Azure |
Updates the state of an Azure SQL Server recommended action. |
| Set-Azure |
Sets a threat detection policy on a server. |
| Set-Azure |
Sets the Transparent Data Encryption (TDE) protector for a SQL server. |
| Start-Azure |
Starts the workflow that runs a recommended index operation. |
| Start-Azure |
Starts the upgrade of a SQL Database server. |
| Start-Azure |
Starts a sync group synchronization. |
| Stop-Azure |
Stops the workflow that runs a recommended index operation. |
| Stop-Azure |
Stops the upgrade of a SQL Database server. |
| Stop-Azure |
Stops a sync group synchronization. |
| Suspend-Azure |
Suspends a SQL Data Warehouse database. |
| Switch-Azure |
Executes a failover of an Azure SQL Database Failover Group. |
| Update-Azure |
Updates an Azure SQL Database Sync Group. |
| Update-Azure |
Updates an Azure SQL Database Sync Member. |
| Use-Azure |
Specifies that a database uses the auditing policy of its host server. |