We're planning a migration from our CMS (based on Oracle CMSDK) to Alfresco. The issue we have goes as follows :
In the current CMS, content is completly stored in the database. We have content assets with metadata which are related to each other. Event images are stored as a blob.
When we want to use alfresco we think we should extract the contentasset to 1) a file and 2) store the metadata (publishing date, status, author, title…) into the Alfresco database. This seems to be very complex.
At the same time we need a solution for internal link management. The content assets in oracle are linked on asset ID, migrating to Alfresco would mean : create file and rewrite assetID_link to AlfrescoID.
Is someone planning a same migration ?
Will ALfresco 1.4 (which I believe will have WCM preview) have special tools to manage migrations ?
Is there a better way to handle this problem ?