publication Properties, Sync Partners Tab

Replication Wizard Help

Replication Wizard Help

publication Properties, Sync Partners Tab

Subscribers to merge publications can synchronize with servers other than the Publisher at which the subscription originated. Synchronizing with alternate partners provides the ability for a Subscriber to synchronize data even if the primary Publisher is unavailable. This feature is also useful when mobile Subscribers have access to a faster or more reliable network connection with an alternate synchronization partner.

Note  Subscribers must be running SQL Server® 2000 in order for you to enable and use alternate synchronization partners. If you have specified Subscriber types other than those running SQL Server 2000, you will be warned that the Subscriber Types option will be changed to servers running SQL Server 2000 and existing subscriptions from that do not meet this requirement will become invalid.

Potential synchronization partners can be the original Publisher of this publication, global Subscribers to this publication (which do not use the Publisher as a proxy when resolving data conflicts), and republishers of this publication.

The following options are available on the Sync Partners tab of the publication Properties dialog box.

Options

Allow Subscribers to synchronize with other partners than the Publisher from which the subscription was created

Enable using alternate synchronization partners.

(checkbox)

Select which potential alternate synchronization partners are enabled for use with this publication. The original Publisher for this publication cannot be disabled.

Partner

The name of the server identified as an alternate synchronization partner for this publication.

Publication Database

The publication database on the alternate synchronization partner which has the necessary data for this publication.

Publication

The name of the publication on the alternate synchronization partner.

See Also

Alternate Synchronization Partners

How Alternate Synchronization Partners Works

Merge Replication