February 23, 2016 at 8:59 am
so we have three different server farms in three different locations. there's a database on each that has a table that needs to be replicated from each location to itself. Will replication work in this instance. Or does it even make sence to use replication in this instance?
server farm1
tablename: polls
replicated to farm2 and 3 to table polls
server farm2
tablename: polls
replicated to farm and 3 to table polls
server farm3
tablename: polls
replicated to farm2 and 1 to table polls
February 23, 2016 at 9:22 am
Can the table be changed on any node, or is there a master table that controls writes?
It's easier if there is a master, but you can implement Peer to Peer Transaction Replication: https://msdn.microsoft.com/en-us/library/ms151196.aspx?f=255&MSPPError=-2147217396
February 23, 2016 at 9:30 am
it can be inserted into by each node. There shouldnt be any modifications.
February 23, 2016 at 9:36 am
Insert is a modification. In this case, you shouldn't have collisions, but there are ways to handle things. I'd urge you to look at replication.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply