How to: Configure Web Synchronization for Merge Replication (Replication Transact-SQL Programming)

To use Web synchronization for replication, follow these steps:

1. Configure a publication to allow Web synchronization.
2. Configure the computer that is running Microsoft Internet Information Services (IIS) to synchronize subscriptions. IIS version 5.0 and IIS version 6.0 are supported.
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.

Configuring the Publication

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

• Replication Transact-SQL programming: How to: Configure a Publication to Allow for Web Synchronization (Replication Transact-SQL Programming)

Configuring the Computer That Is Running IIS

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

• SQL Server Management Studio: How to: Configure IIS for Web Synchronization

Configuring the Subscription

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

• Replication Transact-SQL programming: How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming)

See Also

Other Resources

Web Synchronization for Merge Replication

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
5 December 2005	Changed content: Reorganized content to improve topic usability. Moved existing content into two new topics: How to: Configure a Publication to Allow for Web Synchronization (Replication Transact-SQL Programming) and How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming).