Setup Microsoft SQL Server - EcoSys - 3.1 - Installation & Upgrade - Hexagon

EcoSys Connect Installation and Configuration (Microk8s Kubernetes)

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

Microsoft SQL Server database prerequisites and setup.

Microsoft SQL Server Prerequisites

  1. Enable the "Allow remote connections to server" setting.

EcoSys Connect Collation Support

The EcoSys Connect requires a Case Insensitive (CI) collation.

Setting Up the SQL Server Database

  1. Edit the \database\create\sqlserver\setup\create.sql script:

    • If a password other than "ecuser" is used for "ecuser" login, modify the portion of the script that creates the "ecuser" login and password.

      Create Login as ECUSER with password = ecuser

  2. Execute the create.sql

    Script as SA or a privileged user.

  3. Apply schema updates as follows:

    1. 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. 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: