Starting with SharePlex 8.6.6, the CREATE or DROP TRIGGER DDL on tables in replication can be replicated.
The following steps are required:
On source database set the following Capture parameter and bounce Capture:
sp_ctrl>set param sp_oct_replicate_trigger 1
sp_ctrl>stop capture (make sure it is “stopped by user” and not “stopping”. In case of latter wait till it is stopped by user)
sp_ctrl>start capture
Subsequently any CREATE TRIGGER or DROP TRIGGER DDL on tables in replication will replicate to target and as for CREATE TRIGGER DDL, the trigger created on target will eventually be in a disabled state though it will first be created in an enabled state, albeit very briefly.
Needless to say that the objects referenced in the trigger should exist on the target database.
