dhis2-users team mailing list archive

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

You should have no trouble with migrating all of the organisation
units and data, including all data elements and indicators  data sets,
etc.

Migration of the custom data entry forms can be done, but it is quite
a lot of trouble. It is probably easier to recreate this, at least in
my opinion.

The export/Import process is described here

http://dhis2.org/doc/snapshot/en/user/html/ch18.html

Just export everything from your database and save the DXF file. If
you are going to use the same machine, then change your
hibernate.properties file to point to the new Postgresql database, and
start DHIS. You should have an empty DHIS database at this point.
Next, import the file which you exported in the previous step, and you
should be good to go.

If you encounter any errors, let the list know.

Regards,
Jason


On Thu, Jan 19, 2012 at 6:03 PM, Felix Kayode <felixkayode@xxxxxxxxxxx> wrote:
> Thank you Jason, will I be able to migrate the org units including all
> facilities from the MySQL version? This is the section we are concerned with
> and are afraid we may lose a lot of the information created for the
> facilities. We may not be too concerned about the data elements and forms.
> The data has been collected for only two months and can easily be
> re-entered.
>
>> Date: Thu, 19 Jan 2012 17:44:38 +0200
>> Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
>> From: jason.p.pickering@xxxxxxxxx
>> To: felixkayode@xxxxxxxxxxx
>> CC: dhis2-users@xxxxxxxxxxxxxxxxxxx
>
>>
>> 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
>> >