We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. We like to replicate our SQL Server 2008 databases using merge replication, but going through configuration headaches.
Our SQL Server are running on web front end boxes.
Can Merge replication be set up over the internet. MSDN suggests VPN, but VPN is too fragile to configure. SQL Server 2008 web sync is only meant for sync between server and client, but not for server to server. I wish we could use MySql where this is easy to configure :-(
Has someone attempted this and can let me know if this is even possible?
Thank you.