X
logo
Master your Data
2 December 2011

Synchronise Documents between SharePoint 2007 and 2010

This blog article describes how you might synchronise Documents between SharePoint 2007 and SharePoint 2010 with Data Synchronisation Studio including custom Metadata columns whilst preserving the Created and Modified Timestamps and user accounts.

Here we have a Document Library in SharePoint 2007 with a few Documents and a Folder where going to Synchronise this to a new SharePoint 2010 document library.

image

Here’s the Empty Document Library in SharePoint 2010 which will be the Target

image

To define the project in Data Synchronisation Studio we need to use the SharePoint provider for SharePoint 2007 and the new SharePoint Client API provider for SharePoint 2010.

Connect Data Source A to the SharePoint Provider

image

Connect Data Source B to the SharePoint 2010 Client API Provider

image

Configure the Schema Map like this and add any other meta data columns you also wish to synchronise.

image

Ensure that the Document Library Update Behaviour is set for FileAndMetaData on each side to that the Documents are uploaded.

image

Run a Compare A->B and Synchronise the Documents

image

And now the documents have been synchronised including the Created/Modified Timestamps and User accounts.

image