Table replication

To replicate data-changing operations, tables in the primary database are published. When a table is published, data-changing operations that affect the contents of that table are captured for subsequent distribution to a replicate database.

To receive replicated operations, a replicate database must subscribe to a published table in the primary database. When a replicate database subscribes to a published table, data-changing operations from the primary database can be distributed to a subscribing table in the replicate database.