Replication Topologies
You can configure replication in Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) in a variety of ways. Choose a configuration based on performance and security factors.
The performance of a system depends on the number of devices that must be supported, the frequency with which the devices must synchronize with the server, the connection bandwidth, the timeframe during which synchronization must occur, and the load that each device imposes on the server while synchronizing.
The configuration you choose is influenced by the security requirements of the application you develop.
Basic Topology Rules
The following rules apply when you design a replication topology that includes SQL Server Compact Edition subscribers:
SQL Server Compact Edition cannot be a Publisher or a Distributor.
Two or more devices can share a publication only by subscribing to the same SQL Server publication.A Subscriber must always synchronize with the same Publisher, but can subscribe to multiple publications on that Publisher.
Synchronizing with alternative synchronization partners is not supported.Note
To create a publication that will include SQL Server Compact Edition subscribers, see Creating the Publication.
See Also
Concepts
Network Topologies (SQL Server Compact Edition)