migrate from mysql to postgresql

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

Thanh

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

···

On Mon, Dec 12, 2011 at 12:37 AM, Ngoc Thanh Nguyen thanh.hispvietnam@gmail.com wrote:

Thanh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Knut Staring

Informatics, U. of Oslo

http://hisp.uio.no

+4791880522