topic Re: Migration from Derby to MySql in Alfresco Archive

Migration from Derby to MySql

itettex — Fri, 15 May 2009 08:01:15 GMT

Hi all,we are facing problems with migration from Derby to MySql. Sorry for not beeing the Alfresco experts (but we are working on this 😉 ).Setup: Opensuse 11.1, Alfresco 3.0Problem: We installed Alfresco (by chance with Derby DB) as a beta version for trying, then upgraded to the 3.0 LAB communit

Re: Migration from Derby to MySql

ttortosa — Wed, 22 Jul 2009 10:43:08 GMT

I'm having the same problem, in 3.2 version derby database is not longer supported. I've used a trial version razorsql, but sql that obtains is not syntax correct, and alternative processes aren't successful.

Re: Migration from Derby to MySql

swardi — Mon, 31 May 2010 15:09:10 GMT

I have the same Problem. Did you resolve it. if yes please can you tell me how to do it.

My Problem that i have data (only Spaces and contents no rules or users) and i have to transform it from derby DB to a mysql DB.

Thanks.

Re: Migration from Derby to MySql

vimal — Thu, 14 Jun 2012 05:38:58 GMT

Hi,

We have made use of alfresco 3.0 with derby database due to scalability issues derby has to be migrated to MySQL.Is there any step by step procedure or any relevant documents because all documents related to migration were for alfresco 3.4 and above.

Regards,
Vimal