Export (0) Print
Expand All
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?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.