Set the route version to the new version.
Source Destination Route Proposed Status
Version Version
------ ----------- ------- -------- ------------------
NY_RS LON_RS 1500 1570 Need route upgrade
sysadmin upgrade, "route", LON_RS
Route upgrade for route 'NY_RS.LON_RS' is in progress in the background"In the background, NY_RS starts a routing thread that performs these procedures:
The route upgrade fails and you need to recover the route from the upgrade, you see something similar to:
Source Destination Route Proposed Status
Version Version
------ ----------- ------- -------- ----------------
NY_RS LON_RS 1500 1570 need route
upgrade recovery
If the route upgrade did not proceed and if there are still routes that you need to upgrade, you see something similar to:
Source Destination Route Proposed Status
Version Version
------ ----------- ------- -------- ----------------
NY_RS ROM_RS 1500 1570 need route
upgrade
Successful route upgrade that includes materialization to make information associated with new features available to a newly upgraded Replication Server:
Upgrade for route 'source_rs_name.dest_rs_name' is complete.Successful route upgrade that does not need rematerialization:
Upgrade for route 'source_rs_name.dest_rs_name' is complete. no copying of RSSD information is necessary.Failed route upgrade:
Route upgrade/upgrade recovery fails due to error. The upgrade procedure is not completed. This routing thread will in turn exit.sysadmin upgrade, "route", LON_RS, "recovery"
suspend distributor PS.pdb go resume distributor PDS.pdb go