← Back to team overview

dhis2-users team mailing list archive

Re: MySQL to Postgres Conversion

 

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@xxxxxxxxx>
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
>
> --
> Morten
>
> On Wed, Dec 2, 2015 at 11:42 AM, Hari Haran <mhharan@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> 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
>
>


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

References