Migrates a connection to a different logical cluster or instance.
sp_cluster connection, “migrate”, lc_name, instance_name, “spid_list”
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.
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’
To migrate the current spid, omit spid_list from sp_cluster connection, migrate.