Re: [Dhis2-devs] Postgres to H2

2012-05-02 Thread Bob Jolliffe
Yes its easy enough to do (if you can do without the binary blobs) but requires a bit of massaging - stripping the postgres specific stuff at the top of replacing a few strings. If you are not in a big rush I can help sometime after Friday. I had some sed scripts for most of this somewhere. On 2

Re: [Dhis2-devs] Postgres to H2

2012-05-02 Thread Knut Staring
No recent experience myself, but there seems to be a few recipies out there: http://h2-database.66688.n3.nabble.com/PostgreSQL-gt-H2-data-migrations-td927924.html https://groups.google.com/forum/?fromgroups#!topic/sql-workbench/4ub5n3oF1y8 Knut On Wed, May 2, 2012 at 10:07 PM, Olav Poppe wrote:

[Dhis2-devs] Postgres to H2

2012-05-02 Thread Olav Poppe
Hi, in Liberia at the moment, where they are have problems with offline installations. Were thinking whether DHIS2 Live could be an option, with the build in H2 databse (giving them DHIS2 Live with a "full" database). Does anyone have any experience in getting a postgres database migrated to H2? O