Azure Database PowerShell Reference

Azure Database PowerShell Cmdlets

This section provides reference documentation for PowerShell cmdlets used to manage Azure database services, including Azure SQL Database, Azure Database for MySQL, PostgreSQL, and MariaDB.

Azure SQL Database Cmdlets

Get-AzSqlDatabase Retrieves information about Azure SQL databases.

                            PS C:\> Get-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer"
                        

New-AzSqlDatabase Creates a new Azure SQL database.

                            PS C:\> New-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase"
                        

Set-AzSqlDatabase Updates an Azure SQL database.

                            PS C:\> Set-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase" -MaxSizeBytes 20GB
                        

Remove-AzSqlDatabase Deletes an Azure SQL database.

                            PS C:\> Remove-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase"
                        

Azure Database for MySQL Cmdlets

Get-AzMySqlDatabase Retrieves information about Azure Database for MySQL databases.

                            PS C:\> Get-AzMySqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyMySQLServer"
                        

New-AzMySqlDatabase Creates a new Azure Database for MySQL database.

                            PS C:\> New-AzMySqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyMySQLServer" -DatabaseName "MyMySQLDB"
                        

Remove-AzMySqlDatabase Deletes an Azure Database for MySQL database.

                            PS C:\> Remove-AzMySqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyMySQLServer" -DatabaseName "MyMySQLDB"
                        

Azure Database for PostgreSQL Cmdlets

Get-AzPostgreSqlDatabase Retrieves information about Azure Database for PostgreSQL databases.

                            PS C:\> Get-AzPostgreSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyPostgresServer"
                        

New-AzPostgreSqlDatabase Creates a new Azure Database for PostgreSQL database.

                            PS C:\> New-AzPostgreSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyPostgresServer" -DatabaseName "MyPostgresDB"
                        

Remove-AzPostgreSqlDatabase Deletes an Azure Database for PostgreSQL database.

                            PS C:\> Remove-AzPostgreSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyPostgresServer" -DatabaseName "MyPostgresDB"
                        