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.

SharePoint

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

Connect Data Source B to the SharePoint 2010 Client API Provider

Connect

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

Schema

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

Settings

Run a Compare A->B and Synchronise the Documents

Compare

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

SharePoint

| |