Database Migration from MSSQL to MariaDB

Introduction

With Relution 5.25 the support for Microsoft SQL Server will finally be discontinued. Below you will find instructions (valid from Relution version 5.24.2/ 5.25.0) on how to migrate using the HeidiSQL GUI. If you need support, 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
  12. output: New database Server
  13. database: New database
  14. start migration

After the migration

  1. start Relution
  2. check Relution log if 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)