Hi,

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
Transactional?

Greetings.

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