Get databases from the server

Get-D365Database [[-Name] <String[]>] [[-DatabaseServer] <String>] [[-DatabaseName] <String>]
 [[-SqlUser] <String>] [[-SqlPwd] <String>] [<CommonParameters>]

Get the names of databases on either SQL Server or in Azure SQL Database instance

Get-D365Database

This will show all databases on the default SQL Server / Azure SQL Database instance.

Get-D365Database -Name AXDB_ORIGINAL

This will show if the AXDB_ORIGINAL database exists on the default SQL Server / Azure SQL Database instance.

Get-D365Database -DatabaseName AXDB

This will show all databases on the default SQL Server / Azure SQL Database instance, by establishing the connection against the AXDB database instead of the default "master" database.

Name of the database that you are looking for

Default value is "*" which will show all databases

Type: String[]
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: *
Accept pipeline input: False
Accept wildcard characters: False

The name of the database server

If on-premises or classic SQL Server, use either short name og Fully Qualified Domain Name (FQDN).

If Azure use the full address to the database server, e.g. server.database.windows.net

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 2
Default value: $Script:DatabaseServer
Accept pipeline input: False
Accept wildcard characters: False

The name of the database that you want to connect to, to retrieve the list of databases from

This is useful if the credentials that you are using only have access to a specific database, and not the default "master" database

Default value is fetched from the current configuration on the machine

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 3
Default value: $Script:DatabaseName
Accept pipeline input: False
Accept wildcard characters: False

The login name for the SQL Server instance

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 4
Default value: $Script:DatabaseUserName
Accept pipeline input: False
Accept wildcard characters: False

The password for the SQL Server user

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 5
Default value: $Script:DatabaseUserPassword
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.

Tags: Database, DB, Servicing

Author: Mötz Jensen (@Splaxi)