topic Migrate Community/Mysql to Entreprise/Oracle in Alfresco Archive

Migrate Community/Mysql to Entreprise/Oracle

uskiki85 — Thu, 06 Oct 2011 12:08:13 GMT

Hi,I have to migrate Alfresco Community 3.4.d with MySQL to Alfresco Entreprise with Oracle.I have found a lot of post to install Alfresco Entreprise with Oracle but i have not found how to migrate my data from MySQL to Oracle.Any ideas ?

Re: Migrate Community/Mysql to Entreprise/Oracle

mrogers — Thu, 06 Oct 2011 13:32:46 GMT

I beleive that the migration will be the responsibility of Alfresco support.

Please contact alfresco support for help with migration to Alfresco Enterprise.

Re: Migrate Community/Mysql to Entreprise/Oracle

uskiki85 — Fri, 07 Oct 2011 08:38:53 GMT

Ok so for my test with my Alfresco Entreprise Evaluation, i can't migrate … .

Nobody has already migrate from Mysql to oracle without the Alfresco support ?

Re: Migrate Community/Mysql to Entreprise/Oracle

mrogers — Fri, 07 Oct 2011 09:35:43 GMT

Yes of course you can do it yourself, I'm just pointing out that you don't need to.

The procedure is as for a normal backup and restore but you will also need to deal with the transformation of the mysql data to oracle.

Re: Migrate Community/Mysql to Entreprise/Oracle

uskiki85 — Mon, 10 Oct 2011 14:37:54 GMT

Oracle SQL developper seems to have a function to migrate Mysql data and table to Oracle.

I have to test