Upgrade replicated databases - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation
PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Installation & Upgrade
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

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.

  1. Stop the replication process and backup the databases.

  2. Disable the transfer of data between the host server and the satellite servers. For more information, see Disable replication on a SQL Server instance.

  3. 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.

  4. 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.

  5. 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.

  6. Regenerate the reports database.

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."