Is there a toolkit for migrating DHIS 2 database from MySQL to Postgres.
I tried converting the MySQL tables ‘As It Is’ with necessary Datatype changes using an OpenSource tool FromMySqlToPostgreSql.
The DHIS comes up for Login but after login I get a blank page
Hariharan
HISP-India
Hi Hari
I’m not sure exactly what needs to make the move successful, but did you try and have a look at the logs? should probably be an exception there?
Also, I’m not sure if binary types can be moved over? you might have to clear out your settings
On Wed, Dec 2, 2015 at 11:42 AM, Hari Haran mhharan@yahoo.com wrote:
Is there a toolkit for migrating DHIS 2 database from MySQL to Postgres.
I tried converting the MySQL tables ‘As It Is’ with necessary Datatype changes using an OpenSource tool FromMySqlToPostgreSql.
The DHIS comes up for Login but after login I get a blank page
Hariharan
HISP-India
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Morten
I think I would probably rather try doing meta data and data exports and imports, rather than direct conversions.
Knut
On Wed, Dec 2, 2015 at 11:19 AM, Morten Olav Hansen mortenoh@gmail.com wrote:
Hi Hari
I’m not sure exactly what needs to make the move successful, but did you try and have a look at the logs? should probably be an exception there?
Also, I’m not sure if binary types can be moved over? you might have to clear out your settings
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
–
Morten
On Wed, Dec 2, 2015 at 11:42 AM, Hari Haran mhharan@yahoo.com wrote:
Is there a toolkit for migrating DHIS 2 database from MySQL to Postgres.
I tried converting the MySQL tables ‘As It Is’ with necessary Datatype changes using an OpenSource tool FromMySqlToPostgreSql.
The DHIS comes up for Login but after login I get a blank page
Hariharan
HISP-India
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar