Setting up merge replication between databases on the same network is no problem, but I need to replicate between the
I have tried doing routine backups of NetA_Pub and restoring to NetB (the servernames for both
Any suggestions on what the problem is, or a better way to accomplish this?
If you need a complete copy of
I also don't understand the reason for merge replication in this scenario, or are the subscribers making updates that should go to the publishers?
I suggest you try the following:
You then run steps 3,4 and 5 at the necessary intervals.
This would keep both sides as merge replications in their own domains, but allow you to copy the information you need from NetA to NetB.
Does that help, or am I misunderstanding you?
answered Oct 27 '10 at 01:21 AM
Thanks - yes, you got the gist for the most part. I restore
However, where your Step4 - copy the data from
I've experimented with instead of 'replicating' between the restored
When coming up with the solution, I thought that just using the same merge replication across all the db's would be the easiest to setup and maintain, but now having second/ third thoughts. I'm not familiar with SSIS, is that something that could be a solution?
Sorry if this is hard to follow ;)