Microsoft® .NET Compact Framework (Core Reference)

Using Merge Replication

This section looks in detail at the alternative to RDA: SQL Server CE merge replication (referred to as merge replication from here). Although merge replication is more powerful and simpler to program than RDA, you’ll find that merge replication is more complex to set up, especially the security configuration. This section will start by taking you through the main points.

Note

Remember that merge replication is available only for SQL Server 2000.

Introducing Merge Replication Architecture

Although SQL Server CE merge replication has similarities with SQL Server 2000 merge replication, it is not identical. As with all forms of SQL Server replication, three databases are involved, as follows:

• Publisher

• Distributor

• Subscriber

The ...