What type of replication? - 06-15-2009 , 06:51 AM
I have 50 servers all want to have synchronized with the same information. I
need to replicate 4 BD, 6 Publications and 300 tables (approximately). The
size of the data will be 2.5 GB per year.
My question is: Merge, Bidirectional Transactional or Peer-to-Peer
Re: What type of replication? - 06-15-2009 , 07:28 AM
That depends on your data flow. If you want bi-directional data flow, merge
might work best.
Bi-directional transctional replication which faster than p2p and merge
replication is not really that scalable beyond serveral subscribers.
Peer to Peer likewise it not scalable beyond 10 subscribers.
"default" <default (AT) es (DOT) es> wrote