Implementing Nonpartitioned, Bidirectional, Transactional Replication

You can develop a transactional, nonpartitioned, bidirectional application using the following replication features:

• Reciprocal publications
• Custom stored procedures
• Cycle detection

The sample application presented in this topic illustrates how these features can be combined programmatically on one Microsoft® SQL Server™ installation using two databases (test1 and test2). The sample is built in six steps.

1. Create the databases.
2. Create a bidirectional schema.
3. Create reciprocal publications.
4. Create subscriptions with cycle detection enabled.
5. Create custom stored procedures to apply changes and handle conflicts.
6. Test the application.

See Also

Nonpartitioned, Bidirectional, Transactional Replication