Migrating h2 database to postgreSQL

Q&A
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!

 

2

Hi,

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

http://community.bonitasoft.com/blog/full-open-source-setup-bonita-open-solution-part-2-server

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