Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Configure Web Synchronization for Merge Replication (SQL Server Management Studio)

To use Web synchronization for replication, follow these steps:

  1. Configure the computer that is running Microsoft Internet Information Services (IIS) to synchronize subscriptions. IIS version 5.0, IIS version 6.0, and IIS version 7.0 are supported.

  2. Configure a publication to allow Web synchronization.

  3. Configure one or more subscriptions to use Web synchronization.

Before you configure Web synchronization, we recommend that you read "Security Best Practices for Web Synchronization" in Configuring Web Synchronization. For more information about Web synchronization security, see Security Architecture for Web Synchronization.

Web synchronization requires that you install and configure IIS. After you enable a publication, configure the computer that is running IIS to support Web synchronization. For a more information about IIS installation, see the IIS documentation.

To configure IIS for Web synchronization

To use Web synchronization, first create a publication in the same way that you would for a standard merge topology. For more information, see Publishing Data and Database Objects. If you are using a Publisher for the first time, you must also configure a Distributor and a snapshot share. The Merge Agent at each Subscriber must have read permissions on the snapshot share. For more information, see Configuring Distribution and Securing the Snapshot Folder.

After the publication is created, enable the option to allow for Web synchronization.

To configure a publication to allow Web synchronization

After you enable a publication and configure IIS, create a pull subscription and specify that the pull subscription should synchronize by using IIS. (Web synchronization is supported only for pull subscriptions.)

To configure a subscription to use Web synchronization

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft