Nonpartitioned, Bidirectional, Transactional Replication
Merge replication and transactional replication with immediate or queued updating are key technologies supporting multisite update replication. If you require transactional consistency, and immediate or queued updating is not appropriate, you may want to extend transactional replication programmatically to support nonpartitioned, bidirectional topologies. Microsoft® SQL Server™ replication provides features that allow nonpartitioned, bidirectional replication, but substantial customization and programming is usually required.
To develop a transactional, nonpartitioned, bidirectional solution, use the following replication features:
- Reciprocal publications
- Custom stored procedures
- Cycle detection
For more information about how these features can be combined programmatically to build a nonpartitioned, bidirectional solution, see Implementing Nonpartitioned, Bidirectional, Transactional Replication.