Upgrading the Database - EcoSys - Installation & Upgrade - Hexagon

EcoSys Upgrade

Language
English
Product
EcoSys
Search by Category
Installation & Upgrade
EcoSys Version
9.2

Starting with EcoSys 9.1 and above, upgrading the EcoSys database is done using Liquibase. Liquibase determines the current and target database schema versions and apply the necessary database upgrades, replacing the former method of manually determining the two schema versions and running specific database upgrade scripts in order.

Before running the Liquibase scripts, the EcoSys DB schema must be 0600.0020.0004.0001. See Determining the Database Upgrade Path to find the current database schema version. If not at this version, upgrade the database to this version using the steps in Running 0600.0020.0004.0001and prior schema updates section.

Once upgraded to the 0600.0020.0004.0001, Liquibase will be used to apply all future database schema updates.

Upgrade the Oracle database

  1. Using the new build, copy the \database\liquibase\ folder to your local machine.

  2. Open the \database\ liquibase\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, and classpath based on your environment.

    4. Save the file.

  3. Open a command or shell prompt on the host.

  4. Change directories to \database\liquibase.

  5. Ensure JAVA is on the path.

    For supported Java JDK versions, see Server Java JDK (64-bit)

  6. Using one of the syntaxes below, run the upgrade script to apply the database changes while replacing password (keep the quotes) with the password for the database user specified in the liquibase.properties file.

    For Windows, execute the following command:

    - upgrade.bat "password"

    For Linux, execute the following commands:

    set +H

    ./upgrade.sh "password"

    Set -H

    The result of the command appears as follows:

    • Always enclose the password in double quotes.

For Windows, Escape a double quote (") in the password with an additional double quote. For example, for the password P"ssword, the command would be upgrade.bat "P""ssword"

For Linux, Escape double quote ("), back quote (`), and backslash (\) with a backslash. For example, for the password P"ss`o\d, the command would be ./update.sh "P\"ss\’o\\d"

Upgrade Microsoft SQL Server

  1. Using the new build, copy the \database\liquibase\ folder to your local machine.

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

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

    2. Save the file.

  3. Open a command or shell prompt on the host.

  4. Change directories to \database Liquibase.

  5. Ensure JAVA is on the path.

      For supported Java JDK versions, see Server Java JDK (64-bit)

  6. Using one of the syntaxes below, run the upgrade script to apply the database changes while replacing password (keep the quotes) with the password for the database user specified in the liquibase.properties file.

    For Windows, execute the following command:

    - upgrade.bat "password"

    For Linux, execute the following commands:

    set +H

    ./upgrade.sh "password"

    Set -H

    The result of the command appears as follows:

    • Always enclose the password in double quotes.

For Windows, Escape a double quote (") in the password with an additional double quote. For example, for the password P"ssword, the command would be upgrade.bat "P""ssword"

For Linux, Escape double quote ("), back quote (`), and backslash (\) with a backslash. For example, for the password P"ss`o\d, the command would be ./update.sh "P\"ss\’o\\d"