Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Nov 23 '12 at 18:33

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

add comment

1 Answer 1

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) http://www.jstawski.com/archive/2007/03/06/pull-merge-replication-security-with-sql-server-2005.aspx

How to: Configure a Subscription to Use Web Synchronization (SQL Server Management Studio) http://msdn.microsoft.com/en-us/library/ms345214.aspx

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
add comment

Your Answer

 
discard

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