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 |
---|---|
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. |
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. |
|
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. |