Replication Topologies

You can configure replication in Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) 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 3.5 subscribers:

  • SQL Server Compact 3.5 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 3.5 subscribers, see Creating the Publication.

See Also

Concepts

Network Topologies (SQL Server Compact)

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)