AnsweredAssumed Answered

Migration from Oracle to MS-SQL Server

Question asked by theorbix on Sep 11, 2007
Latest reply on Sep 17, 2007 by kevinr

Are thre any recommended guidelines to migrate an existing Alfresco repository from an Oracle database to MS-SQL Server?

Our existing document repository is currently based on an Alfresco 2.01 Community edition running on Oracle.

Our system administration has planned to upgrade to a new server, where he would like to deploy Alfresco 2.1 Enterprise on a MS-SQL Server database.

What are the recommended steps for the migration?

For instance: will the repository export / import process migrate also user and group definitions and ACLs associated to each space and document being migrated?

Or it will be necessary to manually recreate users and groups, and then reassign all security to each space and document in the repository?