topic Re: MySQL to postgreSQL in Alfresco Archive

MySQL to postgreSQL

enkidu — Tue, 13 Aug 2013 15:57:56 GMT

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 w

Re: MySQL to postgreSQL

kaynezhang — Wed, 14 Aug 2013 02:22:53 GMT

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

Re: MySQL to postgreSQL

enkidu — Wed, 14 Aug 2013 08:44:40 GMT

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.

Re: MySQL to postgreSQL

kaynezhang — Wed, 14 Aug 2013 08:57:04 GMT

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.

Re: MySQL to postgreSQL

rjohnson — Wed, 14 Aug 2013 09:53:31 GMT

You could try Navicat. Its commercial.

Good luck

Bob Johnson