Synchronise SharePoint List

This article describes how to Synchronise a SQL Server Table to a SharePoint list with Data Synchronisation Studio.

Overview

In this example we will Synchronise the Products table from the popular Northwind database to a List in SharePoint.
This example with use a table with a Schema as below.
CREATE TABLE [dbo].[Products] (
    [ProductID] int IDENTITY(1, 1) NOT NULL,
    [ProductName] nvarchar(40) NOT NULL,
    [SupplierID] int NULL,
    [CategoryID] int NULL,
    [QuantityPerUnit] nvarchar(20) NULL,
    [UnitPrice] money DEFAULT(0) NULL,
    [UnitsInStock] smallint DEFAULT(0) NULL,
    [UnitsOnOrder] smallint DEFAULT(0) NULL,
    [ReorderLevel] smallint DEFAULT(0) NULL,
    [Discontinued] bit DEFAULT(0) NOT NULL
)
GO

Step 1 - Connect to the SQL Database

Choose the Connect Data Source link in the Datasource A window to open the Data Source Connection Dialog.
  • Connect to SQL Data Source
    Connect Data Source
  • Connect to SQL Data Source
    Select the Products table on the Data Source
 

Step 2 - Create SharePoint List

Use the SharePoint List Wizard to Create a SharePoint List from the Schema loaded by Data Synchronisation Studio.

Start the Wizard

Start the SharePoint List Wizard

Step through the Wizard

  • Select SharePoint Server
    Select SharePoint Server
  • Select SharePoint Site
    Select SharePoint Site
  • Select List Name
    Select List Name
 

Step 3 - Compare A->B and Synchronise

Run an initial compare to look for the new records that need to be added to SharePoint in this case we should see all records as the SharePoint list contains no records.
  • Compare Results
    Compare Results
  • Start a Synchronisation
    Start a Synchronisation
  • Results in SharePoint
    Product List in SharePoint Populated