Azure Database Cmdlets

Az.Sql Module

Cmdlets for managing Azure SQL Database, SQL Managed Instance, and Azure Synapse Analytics.

Get-AzSqlServer

Gets information about Azure SQL servers.

New-AzSqlServer

Creates an Azure SQL server.

Set-AzSqlServer

Updates an Azure SQL server.

Remove-AzSqlServer

Deletes an Azure SQL server.

Get-AzSqlDatabase

Gets Azure SQL databases.

New-AzSqlDatabase

Creates an Azure SQL database.

Set-AzSqlDatabase

Updates an Azure SQL database.

Remove-AzSqlDatabase

Deletes an Azure SQL database.

Get-AzSqlDatabaseTable

Gets tables in an Azure SQL database.

Get-AzSqlDatabaseIndex

Gets indexes in an Azure SQL database.

Az.MySql Module

Cmdlets for managing Azure Database for MySQL servers.

Get-AzMySqlFlexibleServer

Lists or gets the details of MySQL flexible servers.

New-AzMySqlFlexibleServer

Creates a new MySQL flexible server.

Remove-AzMySqlFlexibleServer

Deletes a MySQL flexible server.

Get-AzMySqlFlexibleServerFirewallRule

Gets firewall rules for a flexible server.

New-AzMySqlFlexibleServerFirewallRule

Creates a firewall rule for a flexible server.

Az.PostgreSql Module

Cmdlets for managing Azure Database for PostgreSQL servers.

Get-AzPostgreSqlFlexibleServer

Lists or gets the details of PostgreSQL flexible servers.

New-AzPostgreSqlFlexibleServer

Creates a new PostgreSQL flexible server.

Remove-AzPostgreSqlFlexibleServer

Deletes a PostgreSQL flexible server.

Get-AzPostgreSqlFlexibleServerFirewallRule

Gets firewall rules for a PostgreSQL flexible server.

New-AzPostgreSqlFlexibleServerFirewallRule

Creates a firewall rule for a PostgreSQL flexible server.

Az.SqlManagement Module

Cmdlets for managing SQL resources across Azure.

Get-AzSqlSyncGroup

Gets Azure SQL Sync Groups.

New-AzSqlSyncMember

Creates a new Azure SQL Sync Member.

Set-AzSqlDatabaseAuditingPolicy

Configures auditing policy for a SQL database.

Az.SqlVirtualNetworkRules Module

Cmdlets for managing SQL Server virtual network rules.

Get-AzSqlVirtualNetworkRule

Gets a virtual network rule for Azure SQL server.

New-AzSqlVirtualNetworkRule

Creates a virtual network rule for Azure SQL server.

Remove-AzSqlVirtualNetworkRule

Deletes a virtual network rule for Azure SQL server.

Az.SqlServer Module

Additional cmdlets for managing Azure SQL Servers and related configurations.

Get-AzSqlServerDisasterRecoveryConfiguration

Gets the disaster recovery configuration for a SQL server.

Set-AzSqlServerCommunicationLink

Updates a SQL server communication link.

Invoke-AzSqlDatabaseFailover

Performs a database failover.