Cmdlets to provide and manage SQL servers for tests.
Returns connection parameters for an existing Azure SQL Server.
Get-SqlTestAzureInstance [[-Subscription] <String>] [[-ResourceGroupName] <String>]
[-ProgressAction <ActionPreference>] [<CommonParameters>]
Retrieves Azure SQL Servers in the selected subscription and resource group and returns the first server with DataSource, ConnectTimeout, and ConnectionString properties. Requires Az modules and an authenticated Azure context.
Connect-AzAccount
PS> Get-SqlTestAzureInstance
Retrieves the first SQL Server from the default PsSqlTestServer resource group in the current subscription.
Captured output (server name redacted):
ResourceGroupName : PsSqlTestServer ServerName : <redacted> FullyQualifiedDomainName : <redacted>.database.windows.net DataSource : <redacted>.database.windows.net ConnectTimeout : 30 ConnectionString : Data Source=<redacted>.database.windows.net;Connect Timeout=30;Authentication=Active Directory Integrated
Specifies the Azure Subscription name.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Specifies the Azure Resource Group name.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: PsSqlTestServer
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
https://abbgrade.github.io/PsSqlTestServer/docs/Get-SqlTestAzureInstance.html