Tutorial: Synchronizing SQL Server and SQL Express

This tutorial contains the following walkthroughs that will help you quickly ramp up on basic database synchronization concepts.

Mandatory Walkthroughs

Walkthrough

Description

Walkthrough: Creating a Sample Server Database

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 Database

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 sync scope related artifacts.

Walkthrough: Provisioning a SQL Express Client

In this walkthrough you will create a SQL Express 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 SQL Express database with artifacts related to sync scope.

Walkthrough: Executing Synchronization [SQL Express]

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

Optional Walkthroughs: Parameterized Scope

Walkthrough

Description

Walkthrough: Defining Filtered Scope and Provisioning Server Database

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

Walkthrough: Provisioning a Client Database with Filtered Scope

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

Walkthrough: Executing Synchronization for the Filtered Scope [SQL Express]

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