Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am currently having a problem with the following Creating a merge replication is simple if the servers are on the same network, i would like to know how can i do a merge replication if the servers are on seperate networks I am using SQL 2008 R2

share|improve this question

migrated from Nov 23 '12 at 18:33

This question came from our site for professional and enthusiast programmers.

There's some very good tutorials on the web about this that go in depth and have lots of screenshots.

I'm assuming you also have to cross untrusted domains, correct? Usually if the domains are trusted it means some sort of network link with AD/LDAP has been established. If that's the case, you're looking at: Merge replication across untrusted domains using web synch

Pull Merge Replication Security with Sql Server 2005 with no Domain Set Up (Largely applies to 2008)

How to: Configure a Subscription to Use Web Synchronization (SQL Server Management Studio)

You will also run into questions such as 'do I use a sql user, do I use security certs? SSL or SQL certs, etc.?' There's going to be a lot of decisions you'll have to make so be prepared to re-do it several times.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.