Upgrade replicated databases - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
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.

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

  2. Consolidate the replicated databases.

    Use Tools > Consolidate Model from Workshare in the Project Management task 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.

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

  4. Upgrade the catalog and model databases.

    Use Tools > Upgrade Version in the Project Management task to upgrade the catalog and model databases to the currently installed version. For more information, see Upgrade versions for all databases in the Project Management User's Guide.

  5. Regenerate the reports database.

    Right-click the model database in the Project Management tree view, and then select Regenerate Reports Database. For more information on regenerating a reports database, see 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."