topic Re: Migration from Oracle to MS-SQL Server in Alfresco Archive

Migration from Oracle to MS-SQL Server

theorbix — Tue, 11 Sep 2007 11:00:55 GMT

Hello,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,

Re: Migration from Oracle to MS-SQL Server

kevinr — Mon, 17 Sep 2007 11:49:43 GMT

The Full Repository Export will indeed export users and groups and ACLs. It does not support exporting WCM projects - but if you are not using them then that won't be a problem.

Thanks,

Kevin

Re: Migration from Oracle to MS-SQL Server

theorbix — Mon, 17 Sep 2007 12:14:46 GMT

Thanks for the response.
We're not using WCM, so this will not be an issue.

Regarding the migration AND release upgrade (starting system: Alfresco 2.01 on Oracle - target system Alfresco 1.1 on MS-SQL Server)… is this an issue?

Maybe the safest thing to do is:
1) Upgrade the original system to Alfresco 2.1
2) Export the whole repository.
3) Import on the target system (already running on version 2.1)

Correct?

Re: Migration from Oracle to MS-SQL Server

kevinr — Mon, 17 Sep 2007 12:44:44 GMT

Yes that is the best route.

Thanks,

Kevin