Steps to upgrade EcoSys Connect Database - EcoSys - Installation & Upgrade - Hexagon PPM

EcoSys Connect Upgrade

PPMProduct
EcoSys
PPMCategory_custom
Installation & Upgrade
Version_EcoSys
1.1

Follow the below steps to update the Connect Oracle or SQL Server database.

Upgrading Oracle Database

Follow the steps below to apply any Database schema changes to the Connect database.

  1. Copy the correct JDBC jar file to the \database\upgrade folder of the unzipped upgrade package.

  2. Open the \database\upgrade\liquibase.properties file for editing

    1. Locate the SQL Server section and add a # character at the start of each line to comment out each of the settings.

    2. Locate the section for Oracle and remove the # character for each setting.

    3. Edit the URL, username, password, and classpath based on your environment.

    4. Save the file.

  3. Open a shell on the host.

  4. Change directories to \database\upgrade.

  5. Ensure JAVA is on the path.
    JRE 1.8 or above is required.

  6. Run the command upgrade.bat

  7. The result of the command appears as follows:

Upgrading Microsoft SQL Server

Follow the below steps to apply any Database schema changes to the Connect database.

  1. Copy the correct JDBC jar file to the \database\upgrade folder of the unzipped upgrade package.

  2. Open the \database\upgrade\liquibase.properties file for editing.

    1. Locate the SQL Server section, set the URL, username, Password, liquibaseSchemaName, and classpath based on your environment.

    2. Save the file.

  3. Open a shell on the host.

  4. Change directories to \database\upgrade.

  5. Ensure JAVA is on the path.

  6. JRE 1.8 or above is required.

  7. Run the command upgrade.bat

  8. The result of the command appears as follows: