Upgrade the configuration database - EcoSys - 3.0 - Installation & Upgrade - Hexagon

Upgrade Oracle database

1. Using the new build, copy the correct JDBC jar file to the \database\upgrade\ folder

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, 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 upgrade script to apply the database changes.

   For Windows, execute the command - upgrade.bat “password”.

   For Linux, execute the following commands:

   set +H

   ./upgrade.sh “password”

   Set -H

   

   • 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”

     The result of the command appears as follows:

     

Upgrade Microsoft SQL Server

1. Using the new build, copy the correct JDBC jar file to the \database\upgrade\ folder

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.

   JRE 1.8 or above is required.

6. Run the upgrade script to apply the database changes.

   For Windows, execute the command - upgrade.bat “password”.

   For Linux, execute the following commands:

   set +H

   ./upgrade.sh “password”

   Set -H

   

   • 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”

     The result of the command appears as follows: