Article Options for Merge Replication

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

There are many options for merge table articles that enable you to customize replication behavior to the needs of your applications. By using merge replication, you can do the following:

  • Use row filters, join filters, and column filters. Filtering table articles enables you to create partitions of data to be published. For more information, see Filter Published Data.

  • Specify whether changes at the Subscriber are uploaded to the Publisher. For applications in which some or all data should be read-only at the Subscriber, download-only articles provide a performance benefit. For more information, see Optimize Merge Replication Performance with Download-Only Articles.

  • Specify that deletes for one or more articles should not be tracked by replication triggers and system tables. This option can be useful in many application scenarios. These include scenarios that use batch deletes that do not need to be replicated. For more information, see Optimize Merge Replication Performance with Conditional Delete Tracking.

  • Specify the processing order of articles to make sure that articles are processed in the order required by your application. For more information, see Specify merge replication options.

  • Specify that a set of related records should be processed as a unit (by default, merge replication processes changes to tables on a row-by-row basis). For more information, see Group Changes to Related Rows with Logical Records.

  • Use conflict detection and resolution for cases in which the same data could be changed at more than one node in a topology. For more information, see Detect and Resolve Merge Replication Conflicts.

  • Specify schema options, such as whether constraints and triggers are copied to the Subscriber. For more information, see Specify Schema Options.

  • Use a business logic handler to respond to many conditions during synchronization. These include data changes, conflicts, and errors. For more information, see Execute Business Logic During Merge Synchronization.

See Also

Publish Data and Database Objects