View All Blog Posts

Synchronise Documents between SharePoint 2007 and 2010

2 December 2011

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.


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

Empty Library

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


Connect Data Source B to the SharePoint 2010 Client API Provider


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


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


Run a Compare A->B and Synchronise the Documents


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


| |