How do I migrate from a H2 Database to MariaDB?

Question

What are the steps that need to be taken in migrating from a H2 Database to MariaDB?

Answer 1

NOTE: Be sure that all messages are processed and errors have been resolved in QIE.

1) Stop QIE in the Service Manager.

2) Install MariaDB Server

   

3) Configure the QIE Service Manager to connect to MariaDB

   Add the following Java Options in the Arguments on the Startup tab of the QIE Service Manager:

   -Dconnection.driver=org.mariadb.jdbc.Driver

   -Dconnection.url=jdbc:mariadb://{server}:{port, default=3306}/{database, default=qie}

   -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect

   -Dconnection.username=???

   -Dconnection.password=???

 

   Note: For more information about the above options refer to Configuring QIE with an Alternate Database Management System section in the QIE install guide.

Comments

If you're doing this on Linux, you'll need to add backslashes ( \ ) to the end of each "-Dconnection" line.  For example:

        -Dconnection.driver=org.mariadb.jdbc.Driver \
        -Dconnection.url=jdbc:mariadb://{server}:{port, default=3306}/{database, default=qie} \
        -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect \
        -Dconnection.username=??? \
        -Dconnection.password=???