How to convert H2 databse to Postgres?

H2 databse is prone to corruption on power failure so to convert the database into Postgres.

  1. First you have to close the software if it is open.
  2. Rename the installation folder i.e Innoventry_backup_date.
  3. Install the new software from https://innoventry.in
  4. Paste the database from last installation folder into data folder of new installation folder.
  5. Launch Innoventry software from new installation folder.
  6. Open the company, if it asks for upgrade say “Yes”.
  7. Close the software and open it again.Do not login and cancel the company selection frame.
  8. Go to the Help > convert H2 Database to postgres > select the database mv.db form new installation folder.
  9. Go to the company selection frame it will show company name with postgres url.
  10. Select the company and open it again.Check if Postgres databse service is running.
  11. If you get an error same database already exists then rename the mv.db file.
  12. After successful conversion of database would be move to “Converted to postgres” folder.

If any problems occured during this conversion, call on customer care number:8055013343.Or email on support@innoventry.in

Powered by BetterDocs

Leave a Reply

Your email address will not be published. Required fields are marked *