SQL Server 2008 R2

You can configure replication in Microsoft 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.

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.

    To create a publication that will include SQL Server Compact 3.5 subscribers, see Creating the Publication.