August 30, 2012 at 1:24 pm
So I currently have transactional replication running from multiple servers A, B, C, -Y (publishers) to one Server Z (Subscriber). All is good. I would like to publish data from server Z to all other servers with the same data. Therefore I would like to use merge replication. So my question is, if I have transitional replication running in one direction (multiple servers) can you overlap replication in the opposite direction with merge replication.
August 31, 2012 at 2:18 am
I'm not an expert on this, but I can't see why this shouldn't work. Unless it's the same data replicated in both directions which means you're creating a loop.
August 31, 2012 at 6:45 am
Great, Thank you... I will try and let you know if it works or fails
September 3, 2012 at 5:50 am
I think there will be conflict when you will create using same table(Articles) in database.
September 3, 2012 at 5:58 am
It will conflict only in the Primary Key case....
Thanks,
Sumit:-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply