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.

Outputs

Microsoft.SqlServer.Management.RegisteredServers.ServerGroup

Returns one ServerGroup object for the group that was successfully moved to its new location. The object represents the moved group at its new position within the Central Management Server hierarchy.

Default display properties (via Select-DefaultView):

• ComputerName: The computer name of the CMS host
• InstanceName: The SQL Server instance name of the CMS
• SqlInstance: The full SQL Server instance name in computer\instance format
• Name: The name of the moved server group
• DisplayName: Display name of the server group for UI presentation
• Description: Text description of the group’s purpose or contents
• ServerGroups: Collection of child server groups nested under this group
• RegisteredServers: Collection of registered servers that belong to this group All properties from the base SMO ServerGroup object are accessible using Select-Object *, including Urn, Parent, ParentServer, and other internal properties.