This topic has not yet been rated - Rate this topic

Nonpartitioned, Bidirectional, Transactional Replication

SQL Server 2000

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)