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.
-
Copy the correct JDBC jar file to the \database\upgrade folder of the unzipped upgrade package.
-
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, password, 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 command upgrade.bat
-
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.
-
Copy the correct JDBC jar file to the \database\upgrade folder of the unzipped upgrade package.
-
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 command upgrade.bat
-
The result of the command appears as follows: