← Back to team overview

dhis2-devs team mailing list archive

Re: migrate from mysql to postgresql

 

On Mon, Dec 12, 2011 at 12:37 AM, Ngoc Thanh Nguyen <
thanh.hispvietnam@xxxxxxxxx> wrote:

> I have a dhis2 db on mysql how to move it to postgresql smoothly?


EnterpriseDB comes with a wizard to do this called the Migration Toolkit as
part of their Postgres Plus solution pack
To try the *Postgres Plus Solution Pack*, download PostgreSQL, let
StackBuilder run when the installation completes, expand the heading:
*Registration
Required and Trial Product*

Have not tried it myself in a very long while, but seem to remember that it
worked well. There are also other tools:
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

Knut


> Thanh
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522

References