Do not deviate from the following sequence of steps. Additionally, do not proceed
to a subsequent step in the workflow until the previous one is complete.
-
Stop the replication process and backup the databases.
-
Disable the transfer of data between the host server and the satellite servers. For more information, see Disable replication on a SQL Server instance.
-
Consolidate the replicated databases. Use Tools > Consolidate Model from Workshare in Project Management to merge all replicated databases at the satellite locations to the databases at the host location to form a single database of each type. For more information, see Consolidate an existing SQL Server configuration. If you are using Oracle, see Consolidate all Oracle databases.
-
Upgrade the site and site schema databases. Using the current version of the software, connect to the host site database through the Database Wizard and upgrade the site and site schema using the Upgrade site and its schema to your currently installed version option. For more information, see Upgrade the site and site schema databases.
-
Upgrade the catalog and model databases. Use Tools > Upgrade Version to upgrade the catalog and model databases to the currently installed version. For more information, see Upgrade versions for all databases.
The database upgrade runs in multiple processes to improve the performance, and is
applicable only for model databases for the current software version. The model upgrade
log file displays the number of processes. For example, "5-5-2018 4:48:59 PM Executing
Parallel MTMC Processing with 4 Processors."