Sidebar

How do I migrate from a H2 Database to MariaDB?

+1 vote
1.9K views
asked Sep 2, 2015 by gary-t-8719 (15,030 points)
What are the steps that need to be taken in migrating from a H2 Database to MariaDB?

1 Answer

+2 votes

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.
answered Sep 2, 2015 by gary-t-8719 (15,030 points)
edited Nov 18, 2015 by michael-h-5027
commented Nov 4, 2015 by jon-t-6024 (560 points)
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=???
...