Configuring Web Synchronization

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

Web synchronization option for merge replication

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.

Merge Replication windows application

Merge Replication windows application
http://technet.microsoft.com/en-us/library/ms146869.aspx

Create merge subscription on sql express

1. to add alias with Sql server configuration
2. create subscription using alias instead of IP

RMO programming

http://msdn2.microsoft.com/en-us/library/ms151819.aspx

SQL Server Express does not include SQL Server Agent, which is typically used to run replication agents. If you use a pull subscription (in which agents run at the Subscriber), you must synchronize the subscription using Windows Synchronization Manager or RMO. For more information, see the following topics:
Windows Synchronization Manager
RMO programming: How to: Synchronize a Pull Subscription (RMO Programming)
Replication does not support the Run As Normal User (RANU) feature of SQL Server Express. For more information about this feature, see the SQL Server Express documentation.