AnsweredAssumed Answered

Merge two repositories

Question asked by zezom on May 12, 2010
Latest reply on May 16, 2010 by zaizi
Hi,
I need to merge two separate repositories of alfresco. At the moment they are different versions but I can upgrade them as required. The higher version one is 3.1.1 Enterprise using oracle as the data base.

I've been trying to figure out a good way to bring over the files from one to the other.

If I just copy them via cifs I loose all version history and meta data.

If I upgrade the lower version repository then do an export and import of the files I keep the meta data but loose the version history.

I've been slowly mapping out the data base and how the tables interact with each other and trying to decide if I want to write an application that can read in the rows of one data base munge the data and insert it into the other one and merge the alf_data directors and refresh the lucene cache. This option will take quite a bit of time to develop and comes with the most risk. of corrupting the database. These are both production servers so need to be careful.

At this point in time the most likely course of action is option two. To upgrade the version and do an export and import of the files and loose the version history.

Does any one know of a "standard" way to merge two repositories together while keeping all of the version history and meta data attached to the nodes?

P.S. when I say meta data I mean node.properties['custom:propertyName']

Outcomes