Relution Signet Customer Hub

Migrate MSSQL to MariaDB

With Relution 5.25 the support for Microsoft SQL Server will finally be discontinued. The following instructions (valid from Relution version 5.24.2/ 5.25.0) describe how to migrate using the HeidiSQL GUI. If support is needed, please contact the Relution Helpdesk Team.

How To guide

Migration

  1. shut down Relution
    1.1 Create new database and configure my.cnf cnf template →
    1.2 Create new database with HeidiSQL

  2. connect old and new database in HeidiSQL

  3. create schema in the new database

  4. In the application.yml update the following values
    4.1 Change database type to mariadb
    4.2 Customize JDBC connection string

     - jdbc:mariadb://<db_server>:<db_port>/<db_name>?useServerPrepStmts=true

    4.3 Update DB username and password

  5. Start Relution against the new DB with foreground.bat with + parameter

    /relution/windows-bin/foreground.bat --database-migration-only

  6. Exit Relution

  7. right-click on the old database

  8. database export

  9. databasechangelog + DatabaseChangeLockLock Table + deselect all views + JGROUPSPing

  10. max INSERT length to 10k

  11. deselect all databases and tables

    HeidiSQL database export dialog with databasechangelog and views deselected for MSSQL migration

  12. output: New database Server

  13. database: New database

  14. start migration

After the migration

  1. start Relution
  2. check Relution log if the start works correctly
  3. log in to Relution and check whether resources can be loaded
  4. open Device Inventory (check whether the database views open)