Postgres to H2

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?

Olav

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 <olav.poppe@gmail.com> wrote:

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?

Olav

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

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 May 2012 21:07, Olav Poppe <olav.poppe@gmail.com> wrote:

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?

Olav

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp