Sample Applications for Peer-to-Peer Synchronization
The Sync Services for ADO.NET 2.0 documentation contains complete applications for peer-to-peer synchronization in the how-to topics. For more information, see Programming Common Peer-to-Peer Synchronization Tasks. The following sample applications are installed by the Sync Framework SDK. The Sync Framework SDK is available at this Microsoft Web site.
SharingAppDemo-DecoupledTracking
SharingAppDemo-CoupledTracking
SharingAppDemo-Conflicts
SharingAppDemo-ColumnMapping
SharingAppDemo-TombstoneCleanup
All the applications contain similar application code and have a similar graphical interface. The applications allow you to connect to three peer databases, make changes in those databases, and then synchronize the changes. Each application focuses on a different aspect of synchronization, such as decoupled change tracking or conflict handling.
To use each sample application
Open the setup directory for the sample that you want to run, for example SharingAppDemo-Conflicts\setup.
In SQL Server Management Studio, execute peer1_setup.sql and then peer1_procs.sql. This creates a database and tables, and a set of stored procedures that Sync Services uses to select and apply changes to each peer. Repeat this step for the peer2 and peer3 scripts.
In SQL Server Management Studio, open demo.sql and execute the
Configure Scope Members
section at the top of the script.In Visual Studio, open the solution, such as SharingAppDemo-Conflicts.sln.
Build and run the project.
Make data changes and synchronize the peers.