Replicating INSERT and DELETE statements

For SQL Remote, the INSERT and DELETE statements are the simplest statements to replicate:

When an INSERT statement is executed on one database, it is sent as an INSERT statement to the subscribed databases in the SQL Remote system.
When a DELETE statement is executed on one database, it is sent as a DELETE statement to the subscribed databases in the SQL Remote system.

Consolidated database

SQL Remote copies each INSERT or DELETE statement from the consolidated database transaction log, and sends them to each remote database that subscribes to the row being inserted or deleted. When only a subset of the columns in the table is subscribed to, the INSERT statements sent to the remote databases contain only those columns.

Remote databases

SQL Remote copies each INSERT or DELETE statement from a remote database transaction log and sends it to the consolidated database that subscribes to the row being inserted or deleted. The consolidated database then applies the statement, which results in writing to its transaction log. When the consolidated database transaction log is processed by SQL Remote, the changes are eventually propagated to the other remote sites. SQL Remote ensures that statements are not sent to the remote user that initially executed them.