dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <felixkayode@xxxxxxxxxxx> 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     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>