Migrating h2 database to postgreSQL

Submitted by future_healthcare on Thu, 11/07/2013 - 16:35
1
0
-1

Hi everyone,

Does anyone has any experience migrating h2 (with data already on the db) to postgreSQL ? Is there something i need to be paying attencion in particular?

Thank you very much!

1 answer

Submitted by rafael.vianna on Thu, 11/07/2013 - 18:06
1
+1
-1

Hi,

I followed this tutorial and everything worked fine about the postgres part -->

http://community.bonitasoft.com/blog/full-open-source-setup-bonita-open-...

Point is: It was a new instance, no data were avaiable, just the empty tables of postgres instead of the H2 ones.

The only thing I had to be careful was the part about filling the username and password at the XML files of bonita. I did something like typing 'BONITA ' at username and of course, didn't worked.

Hope it can help a bit,

[]'s

Notifications