sp_cluster connection, migrate

Description

Migrates a connection to a different logical cluster or instance.

Syntax

sp_cluster connection, “migrate”, lc_name, instance_name, “spid_list

Parameters

lc_name – is the name of the logical cluster.

instance_name – is the name of the instance.

spid_list – is the list of spids you are migrating. Separate multiple spids with semicolons.

Examples

Moves the connection with a spid of 73 into the SalesLC cluster:

sp_cluster connection, migrate, SalesLC, NULL, ‘73’

Moves the current connection to the “ase3” instance:

sp_cluster connection, migrate, NULL, ase3

Moves connections with spid values of 73 and 75 into “ase3” instance and the SalesLC cluster:

sp_cluster connection, migrate, SalesLC, ase3, ’73;75’

Usage

To migrate the current spid, omit spid_list from sp_cluster connection, migrate.