Skip to content

Get-AzureDatabase

Azure: Gets Azure SQL databases

param(
	[Parameter(Mandatory = $true)]
	[string]$ResourceGroupName,

	[Parameter(Mandatory = $true)]
	[string]$ServerName,

	[Parameter(Mandatory = $false)]
	[string]$DatabaseName
)

try {
	Import-Module Az.Sql -ErrorAction Stop
	
	[hashtable]$cmdArgs = @{ 'ResourceGroupName' = $ResourceGroupName; 'ServerName' = $ServerName; 'ErrorAction' = 'Stop' }
	if ($DatabaseName) { $cmdArgs.Add('DatabaseName', $DatabaseName) }

	$databases = Get-AzSqlDatabase @cmdArgs
	Write-Output $databases
} catch {
	Write-Error $_
	exit 1
}

The name of the resource group.

The name of the Azure SQL Server.

The name of the database (optional).

An interactive directory of PowerShell scripts.