Contents Index How statements are replicated Replication of updates

SQL Remote User's Guide
  Principles of SQL Remote Design
    How statements are replicated

Replication of inserts and deletes


INSERT and DELETE statements are the simplest replication case. SQL Remote takes each INSERT or DELETE operation from the transaction log, and sends it to all sites that subscribe to the row being inserted or deleted.

If only a subset of the columns in the table is subscribed to, the INSERT statements sent to subscribers contains only those columns.

The Message Agent ensures that statements are not replicated to the user that initially entered them.


Contents Index How statements are replicated Replication of updates