Skip to content

Copy-DBPoolParentContainer

SYNOPSIS

Clones the specified DBPool parent container(s) using the DBPool API.

SYNTAX

byId (Default)

Copy-DBPoolParentContainer -Id <Int32[]> [-ContainerName_Append <String>] [-Duplicate] [<CommonParameters>]

byDefaultDatabase

Copy-DBPoolParentContainer -DefaultDatabase <String[]> [-ContainerName_Append <String>] [-Duplicate]
 [<CommonParameters>]

DESCRIPTION

This function clones the specified DBPool parent container(s) using the DBPool API. The cloned container(s) will have the same parent container as the original container(s) and will be appended with the specified string.

EXAMPLES

EXAMPLE 1

Clones the DBPool parent container with the ID 1234.

Copy-DBPoolParentContainer -Id 1234

EXAMPLE 2

Clones the DBPool parent container with the DefaultDatabase 'exampleParentA'.

Copy-DBPoolParentContainer -DefaultDatabase 'exampleParentA'

EXAMPLE 3

Clones the DBPool parent containers with the IDs 1234 and 5678 and appends 'copy' to the cloned container name.

Copy-DBPoolParentContainer -Id 1234, 5678 -ContainerName_Append 'copy'

EXAMPLE 4

Clones the DBPool parent containers with the DefaultDatabase 'exampleParentA' and 'exampleParentB' even if similar containers already exist.

Copy-DBPoolParentContainer -DefaultDatabase 'exampleParentA', 'exampleParentB' -Duplicate

EXAMPLE 5

Clones the DBPool parent containers with the DefaultDatabase 'exampleParentA' and 'exampleParentB' and appends a number to any duplicate clones.

Copy-DBPoolParentContainer -DefaultDatabase 'exampleParentA', 'exampleParentB', 'exampleParentA

Parent Container [ Id: 7, Name: exampleParentB staging ] 'create' command sent for new Container [ exampleB staging(clone) ]
Parent Container [ Id: 3, Name: exampleParentA on SQL 1.2.3 ] 'create' command sent for new Container [ exampleA(clone-1) ]
Parent Container [ Id: 3, Name: exampleParentA on SQL 1.2.3 ] 'create' command sent for new Container [ exampleA(clone-2) ]
Parent Container [ Id: 4, Name: exampleParentB on 4.5.6 ] 'create' command sent for new Container [ exampleB(clone) ]

PARAMETERS

-Id

The ID(s) of the parent container(s) to clone.

Type: Int32[]
Parameter Sets: byId
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False

-DefaultDatabase

The DefaultDatabase(s) of the parent container(s) to clone.

Type: String[]
Parameter Sets: byDefaultDatabase
Aliases:

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

-ContainerName_Append

The string to append to the cloned container name. The default value is 'clone'.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: Clone
Accept pipeline input: False
Accept wildcard characters: False

-Duplicate

If specified, the function will clone the parent container(s) even if a similar container already exists.

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

[int] - Array of ID(s) of the parent container(s) to clone

[string] - Array of DefaultDatabase(s) of the parent container(s) to clone

OUTPUTS

[PSCustomObject] - Object containing the cloned container(s) information

NOTES

Does not clone any parent containers with 'BETA' in the name.

Also removes parent name suffixes like 'on Database v1.2.3' before appending the ContainerName_Append string.

This function will also append a number to the cloned container name if multiple matching clones are created with same parent at once, or for any matching clones that already exist when using the -Duplicate switch.

https://datto-dbpool-refresh.kentsapp.com/Copy-DBPoolParentContainer/