Az.SqlManagement Module
The Az.SqlManagement module provides cmdlets for managing Azure SQL resources such as databases, servers, elastic pools, and more.
| Cmdlet | Synopsis | Details |
|---|---|---|
| Get-AzSqlDatabase | Retrieves one or more Azure SQL databases. |
Syntax Get-AzSqlDatabase
-ResourceGroupName <String>
-ServerName <String>
[-DatabaseName <String>]
[-Expand <String>]
[
Examples # Get all databases on a server Get-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" # Get a specific database Get-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "mydb" |
| New-AzSqlDatabase | Creates a new Azure SQL database. |
Syntax New-AzSqlDatabase
-ResourceGroupName <String>
-ServerName <String>
-DatabaseName <String>
[-Edition <String>]
[-ServiceObjectiveName <String>]
[-Collation <String>]
[-MaxSizeBytes <Int64>]
[
Examples # Create a basic database
New-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "newdb"
# Create a Premium database with 500 GB max size
New-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "bigdb" `
-Edition "Premium" -ServiceObjectiveName "P2" -MaxSizeBytes 536870912000
|
| Remove-AzSqlDatabase | Deletes an Azure SQL database. |
Syntax Remove-AzSqlDatabase
-ResourceGroupName <String>
-ServerName <String>
-DatabaseName <String>
[-Force]
[
Examples # Delete a database with confirmation Remove-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "olddb" # Delete without prompt Remove-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "olddb" -Force |
| Set-AzSqlDatabase | Updates properties of an existing Azure SQL database. |
Syntax Set-AzSqlDatabase
-ResourceGroupName <String>
-ServerName <String>
-DatabaseName <String>
[-Edition <String>]
[-ServiceObjectiveName <String>]
[-MaxSizeBytes <Int64>]
[
Examples # Scale database to S3 performance level
Set-AzSqlDatabase -ResourceGroupName "MyRG" -ServerName "myserver" -DatabaseName "mydb" `
-Edition "Standard" -ServiceObjectiveName "S3"
|
| Get-AzSqlServer | Gets information about Azure SQL servers. |
Syntax Get-AzSqlServer
-ResourceGroupName <String>
[-ServerName <String>]
[
Examples # List all servers in a resource group Get-AzSqlServer -ResourceGroupName "MyRG" # Get a specific server Get-AzSqlServer -ResourceGroupName "MyRG" -ServerName "myserver" |