Hi Felix, You should be able to migrate most data with the export format (DXF) and import this into a seperate instance which uses Postgres. Most (but not all) of the metadata will be migrated. Some things (users, custom data entry forms) and some other metadata elements will either need to be recreated manually. There are possibly some tools which can convert MySQL to Postgresql format (many here http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL) . In general, I would try first with DXF, see what is missing, and then think about manually recreating things. Other ETL tools like Pentaho may make things a bit easier, but one must be exceedingly careful about direct injection into the DHIS2 database.
Others may have some more specific reccomendations and experience. Best regards, Jason On Thu, Jan 19, 2012 at 4:20 PM, Felix Kayode <[email protected]> wrote: > Hi, > > I am presently working on a new HMIS project in Ethiopia and require some > advice. We recently (2 months ago)installed a DHIS online system using MySQL > and wish to migrate to PostgreSQL, > without losing information on the table structure or data which have just > been entered. How can this be done? > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
