Switches the 2 databases. The Old wil be renamed _original

Switch-D365ActiveDatabase [[-DatabaseServer] <String>] [[-DatabaseName] <String>] [[-SqlUser] <String>]
 [[-SqlPwd] <String>] [-SourceDatabaseName] <String> [[-DestinationSuffix] <String>] [-EnableException]
 [<CommonParameters>]

Switches the 2 databases. The Old wil be renamed _original

Switch-D365ActiveDatabase -SourceDatabaseName "GoldenConfig"

This will switch the default database AXDB out and put "GoldenConfig" in its place instead. It will use the default value for DestinationSuffix which is "_original". The destination database "AXDB" will be renamed to "AXDB_original". The GoldenConfig database will be renamed to "AXDB".

Switch-D365ActiveDatabase -SourceDatabaseName "AXDB_original" -DestinationSuffix "_reverted"

This will switch the default database AXDB out and put "AXDB_original" in its place instead. It will use the "_reverted" value for DestinationSuffix parameter. The destination database "AXDB" will be renamed to "AXDB_reverted". The "AXDB_original" database will be renamed to "AXDB".

This is used when you did a switch already and need to switch back to the original database.

This example assumes that the used the first example to switch in the GoldenConfig database with default parameters.

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: 1
Default value: $Script:DatabaseServer
Accept pipeline input: False
Accept wildcard characters: False

The name of the database

Type: String
Parameter Sets: (All)
Aliases: DestinationDatabaseName

Required: False
Position: 2
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: 3
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: 4
Default value: $Script:DatabaseUserPassword
Accept pipeline input: False
Accept wildcard characters: False

The database that takes the DatabaseName's place

Type: String
Parameter Sets: (All)
Aliases: NewDatabaseName

Required: True
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

The suffix that you want to append onto the database that is being switched out (DestinationDatabaseName / DatabaseName)

The default value is "_original" to mimic the official guides from Microsoft

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 6
Default value: _original
Accept pipeline input: False
Accept wildcard characters: False

This parameters disables user-friendly warnings and enables the throwing of exceptions This is less user friendly, but allows catching exceptions in calling scripts

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
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.

Author: Mötz Jensen (@Splaxi)

Author: Rasmus Andersen (@ITRasmus)