Bi-Directionnal Replication With SQL Server

Question

Is there a way to make a bi-directionnal Replication with SQL Server ?

(BDD 1) Table 1 <=> (BDD 2) Table 1

Thanks.

Answer 1

There are a few solutions that might suit your need.

1. Merge replication
2. Peer to peer transactional replication
3. Database mirroring

Each of them has its own advantages and disadvantages. Choosing one depends on the nature of your scenario.