Upgrade the Oracle database
-
Using the new build, copy the correct JDBC jar file to the \database\upgrade\ folder
-
Open the \database\upgrade\liquibase.properties file for editing
-
Locate the SQL Server section and add a # character at the start of each line to comment out each of the settings.
-
Locate the section for Oracle and remove the # character for each setting.
-
Edit the URL, username, and classpath based on your environment.
-
Save the file.
-
-
Open a shell on the host.
-
Change directories to \database\upgrade.
-
Ensure JAVA is on the path.
JRE 1.8 or above is required.
-
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
-
Using the new build, copy the correct JDBC jar file to the \database\upgrade\ folder
-
Open the \database\upgrade\liquibase.properties file for editing
-
Locate the SQL Server section, set the URL, username, Password, liquibaseSchemaName, and classpath based on your environment.
-
Save the file.
-
-
Open a shell on the host
-
Change directories to \database\upgrade
-
Ensure JAVA is on the path.
JRE 1.8 or above is required
-
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:
-