Connector Improvement: Ability to replicate execution of stored procedure
We replicate from Sybase ASE1 to ASE2 using sybase replication server. The changes applied to ASE2 are extracted using HVR capture and sent to downstream locations. On Sybase, we use stored procedure replication - where in Stored Procedure execution is replicated - Sybase Repliation Server executes stored procedure on target, instead of applying changes captured on primary. This helps a lot to cut down traffic and reduces processing for large batches. We achieve this by below option of sp_setrepproc.
sp_setrepproc procname,'function'
On ASE1 and ASE2 we have this option set for certain procedures. With this setting in place on ASE2, HVRCAPTURE ignores the changes and introduces data discrepancy between ASE2 and targets. We need ability in HVR capture to track changes made by stored procedure which is marked for replication with above method.
-
Hi Ankur,
We are tracking another enhancement request like this so I am closing this as duplicate in our internal system.
The team working with you on a regular basis is coordinating a call to discuss how we may be able to enable a capability like this.
Mark.
Please sign in to leave a comment.
Comments
1 comment