Stored procedure replication

In addition to replicating data-changing operations in tables, ASE Replicator can replicate stored procedure invocations in the primary database. Replicating a stored procedure invocation can be more efficient than replicating the individual data-changing operations it produces.

When a stored procedure in a primary database is published for replication, ASE Replicator captures and records the input parameter values that are specified when the stored procedure is invoked. When a replicate database subscribes to a published stored procedure, the stored procedure invocation in the primary database is distributed to the replicate database as a remote procedure call (RPC).

When a published stored procedure generates an operation that affects the data in a published table, ASE Replicator ignores the data-changing operation generated by that stored procedure and replicates only the stored procedure’s invocation.