Run database upgrade scripts - Intergraph Smart Construction - 2019 (7.0) - Installation & Upgrade - Hexagon PPM

Intergraph Smart Construction Installation and Upgrade (2019)

Language
English
Product
Intergraph Smart Construction
Search by Category
Installation & Upgrade
Smart Construction Version
2019(7.0)
  1. Browse to the Upgrades folder located under the LoadFiles folder in the Smart Construction installation location. For example, navigate to [Drive]:\Program Files (x86)\SmartConstruction\2019\LoadFiles\Upgrades.

  2. If you are upgrading from the most recent version of Smart Construction, browse to the folder named for the version of Smart Construction you are upgrading to. For example, if you are upgrading to version 2019, navigate to the 2019 folder.

  3. If you are upgrading from a version of Smart Construction that is older than the most recent previous version, you must begin by running scripts for the next version after your current version, and then continue for each subsequent version in sequence. For example, if you are upgrading from version 2015R2, you would begin by running scripts in the 2017 folder, and then the 2018 folder.

  4. Browse to the folder named DatabaseScripts. Each of these SQL scripts needs to be executed against the database.

    You will need a database administrator to run these scripts using the tool that is appropriate for your database implementation. For example, an Oracle administrator could use SQLPlus, and a SQL Server administrator could use Management Studio, but other tools may be required in your environment.

  5. If you are upgrading from a version of Smart Construction that is older than the most recent previous version, repeat this process as needed until you have finished running all the scripts for the new version.

  6. After running all SQL scripts, recycle the Internet Information Services (IIS) application pools for your project's site. For more information on resetting IIS application pools, see your Microsoft documentation.