Tutorial: Synchronizing SQL Server and SQL Server Compact

This tutorial contains the following walkthroughs that will help you quickly ramp up on basic database synchronization concepts. It covers basic scenarios. The other topics in Synchronizing SQL Server and SQL Server Compact section cover both basic and advanced scenarios with more in-depth technical details.

Mandatory Walkthroughs

Walkthrough

Description

Walkthrough: Creating a Sample Server Database [Tutorial]

In this walkthrough you will create a sample SQL Server database that you will use later in a synchronization scenario.

Walkthrough: Defining Scope and Provisioning a Server

In this walkthrough you will create a console application that defines a sync scope and provision the SQL Server database that you created in previous walkthrough with scope related artifacts.

Walkthrough: Provisioning a SQL Compact Client

In this walkthrough you will create a SQL Server compact database, which acts as a client for the SQL Server database you created earlier in this tutorial, and create a console application that provisions the compact database with artifacts related to sync scope.

Walkthrough: Executing Synchronization

In this walkthrough, you will create a console application that kicks off synchronization process between the SQL Server and SQL Server compact databases you created in previous walkthroughs.

Optional Walkthroughs: Snapshot Initialization

Walkthrough

Description

Walkthrough: Provisioning another SQL Compact Client using Snapshot Initialization

In this walkthrough you will create and initialize a second SQL Server compact client by using the snapshot of SQL Server compact client you created earlier in this tutorial.

Walkthrough: Executing Synchronization with Second Client

The second compact database should already be in sync with the server database because it is a snapshot of the first compact database, which was already synchronized with the server database.

In this walkthrough you will create a console application that synchronizes the second compact client with the server, adds a new record to the server, synchronizes the second compact client with the server, and also synchronizes the first compact client with the server.

Optional Walkthroughs: Filtered Scope

Walkthrough

Description

Walkthrough: Defining Filtered Scope and Provisioning Server

In this walkthrough you will create a console application that defines a filtered scope and provisions server database with scope related artifacts.

Walkthrough: Provisioning a Client with Filtered Scope

In this walkthrough you will create a console application, which provisions a SQL Server compact client database with artifacts related to the filtered scope.

Walkthrough: Executing Synchronization for the Filtered Scope

In this walkthrough you will create a console application that synchronizes the compact database with the server database.