Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » Replication Design for SQL Remote » Principles of SQL Remote design » How statements are replicated

 

Replication of procedures

Any replication system is faced with a choice between two options when replicating a stored procedure call:

  • Replicate the procedure call   A corresponding procedure is executed at the replicate site, or

  • Replicate the procedure actions   The individual actions (INSERTs, UPDATEs, DELETEs, and so on) of the procedure are replicated.

SQL Remote replicates procedures by replicating the actions of a procedure. The procedure call is not replicated.