Field Mapping

error message: THE MERGE PROCESS WAS UNABLE TO CREATE A NEW GENERATION AT THE “SUBSCRIBER”. TROUBLESHOOT BY RESTARTING THE SYNCHRONIZATION WITH VERBOSE HISTORY LOGGING AND SPECIFY AN OUT PUT FILE TO WHICH TO WRITE. I tried "update sysmergepublications set [generation_leveling_threshold] = 0" on both Subscriber and Publisher, still it didn't work. Then I tried "select count (*) from dbo.MSmerge_contents" and "select count (*) from dbo.MSmerge_genhistory" on the Subscriber The both query was running indefinely with no results, instanly I realised there is some Locking problem. In desperation I restarted the Subscriber Database Engine and started the Agent. Magic! Replication was successfull.

Configuring Web Synchronization Configuring the Publication : How to: Configure a Publication to Allow for Web Synchronization (SQL Server Management Studio) Configuring the Computer That Is Running IIS: How to: Configure IIS for Web Synchronization A. Configuring Secure Sockets Layer: Download and install SelfSSL for free B. Configuring the Computer That Is Running IIS by Using the Configure Web Synchronization Wizard: " On the computer that is running IIS, start SQL Server Management Studio. Connect to the Publisher, and then expand the server node. Expand the Local Publications folder, right-click the publication, and then click Configure Web Synchronization. In the Configure Web Synchronization Wizard, on the Subscriber Type page, select SQL Server. On the Web Server page: Select the instance of IIS that will synchronize subscriptions. Select Create a new virtual directory. In the lower pane of the page, expand the instance of IIS, expand Web Sites, and then click Default Web ...

1. Download and install SelfSSL. By default, the application is installed to :\Program Files\IIS Resources\SelfSSL. Application and documentation shortcuts are copied to :\Documents and Settings\All Users\Start Menu\Programs\IIS Resources\SelfSSL. 2. Run SelfSSL: To run SelfSSL with default values for all parameters, locate the installation directory for the application, and then double-click SelfSSL.exe. or get your own server certificate if already installed. 3. Expand the Local Publications folder, right-click the publication, and then click Configure Web Synchronization. Create a new virtual directory. /websync

http://msdn2.microsoft.com/en-us/library/ms151319.aspx SQL Server 2005 Books Online Implementing Replication over the Internet Replicating data over the Internet allows remote, disconnected users to access data when they need it using a connection to the Internet. Replicate data over the Internet using: A Virtual Private Network (VPN). For more information, see Publishing Data over the Internet Using VPN . The Web synchronization option for merge replication. For more information, see Web Synchronization for Merge Replication . All types of Microsoft SQL Server replication can replicate data over a VPN, but you should consider Web synchronization if you are using merge replication.