Move-DbaRegServerGroup

Synopsis

Moves registered server groups to different parent groups within SQL Server Central Management Server (CMS)

Description

Moves registered server groups to new locations within your Central Management Server hierarchy. This lets you reorganize your CMS group structure without using SQL Server Management Studio manually. You can move groups between different parent groups or relocate them to the root level, helping you maintain organized server collections as your environment grows or changes.

Syntax

Move-DbaRegServerGroup
    [[-SqlInstance] <DbaInstanceParameter[]>]
    [[-SqlCredential] <PSCredential>]
    [[-Group] <String[]>]
    [-NewGroup] <String>
    [[-InputObject] <ServerGroup[]>]
    [-EnableException]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Move-DbaRegServerGroup -SqlInstance sql2012 -Group HR\Development -NewGroup AD\Prod

Moves the Development group within HR to the Prod group within AD

Example: 2

PS C:\> Get-DbaRegServerGroup -SqlInstance sql2017 -Group HR\Development| Move-DbaRegServerGroup -NewGroup Web

Moves the Development group within HR to the Web group

Required Parameters

-NewGroup

Specifies the destination group where the selected groups will be moved. Accepts group paths like ‘AD\Prod’ or ‘Web’, or use ‘Default’ to move to the root level.
The destination group must already exist in the Central Management Server hierarchy.

Optional Parameters

-SqlInstance

The target SQL Server instance or instances.

-SqlCredential

Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.
For MFA support, please use Connect-DbaInstance.

-Group

Specifies the registered server group(s) to move within your Central Management Server hierarchy. Accepts group paths like ‘HR\Development’ or ‘Production\WebServers’.
Use this when you need to select specific groups to relocate rather than piping group objects from Get-DbaRegServerGroup.

-InputObject

Accepts registered server group objects from Get-DbaRegServerGroup for pipeline operations. Use this when you want to filter or manipulate groups before moving them.
This parameter enables advanced scenarios like moving multiple groups based on complex criteria or properties.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with “sea of red” exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this “nice by default” feature off and enables you to catch exceptions with your own try/catch.

-WhatIf

Shows what would happen if the command were to run. No actions are actually performed.

-Confirm

Prompts you for confirmation before executing any changing operations within the command.