Migrating RMsis from H2 to MySQL

Owned by Sanjay Sahani
Last updated: Jul 30, 2014

Question : I had configured RMsis with internal/ H2 database. Can I switch my database to an external database?

Answer :

  • Yes, you can switch your database from H2/ internal database to MySQL database.
  • In order to migrate your database from H2 to MySQL, please go through our database migration guide at : http://docs.optimizory.com/display/notes/Migrating+RMsis+from+H2+to+MySQL .
  • The process mentioned in this migration guide has been tested by us as well as a few customers without any issues.
  • Note : 
    • Please take a backup of your database before migrating it from H2 to MySQL.
    • During this process, you will need a "Blank RMsis database" file. 
    • Please go through the "Resources / Tools Required" section of the above mentioned link and if the "Blank RMsis database" file for the version of RMsis currently being used by you is not available on this page, please let us know.
    • We will provide you with appropriate "Blank RMsis database" file once you let us know the version of RMsis currently being used by you.