MySQL to postgreSQL

[enkidu]

Hi mates, i have an old alfresco installation 3.4 which comes with mysql. now i wanna upgrade alfresco up to 4.2.
i guess if i go on with mysql the upgrade isnt that painful.. but what if i want to use postgresql.

why is it that alfresco didnt come up with a migration tool. something like a wizard which doin all the painful stuff for u. is there something?

or did i have to export the mysql database then use a 3rd party application which converts the mysql export format to a postgresql format that can be used, cross my fingers and pray to god, vishnu, odin, zeus and all the other gods out there?

alfresco upgrades should be something like: "select old alfresco directory" -> "next" -> "choose target database" -> finish.. would be a dream but until now its more like a nightmare.

[kaynezhang]

Personally I think the most time saving option is migration from MySQL to PostgreSQL

[enkidu]

hi kaynezhang.. thnx for ur reply.. i guess u mean dump the mysql database and use a 3rd party tool. any hints which tool is useful and is under the GPL.

[kaynezhang]

There are many 3rd party tools can migrate from one database to another database.
Generally migration tool works like this
1.connection to source database and target database at the same time
2.optionlly you can choose tables that you want to migrate
3.migration tool pull data from source db and load into target db.

[rjohnson]

You could try Navicat. Its commercial.

Good luck

Bob Johnson