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

Upgrade the 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 command update.bat <DB Password>

   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 command upgrade.bat

7. The result of the command appears as follows: