Disable Delete Trigger Option in LTRS

[Former Member]

Hi SLT expert, we want to use the "Disable Delete Trigger" (seems to be new) option for some of our tables due to mass deletion of records coming in a near future project. Those tables are already replicating and because the high volume of data, we want to enable this option without re-starting the replication for those tables.This option looks like new in LTRS but I want to know, if the replication is already active, how can we set it to prevent deleted record to be replicated. We are currently using ODQ replication scenario.

What are the steps required to disable the delete trigger when the replication is already enable on the table?

Thanks in advance for your help!

We are at version DMIS 2011_1_731 SP09

Best regards,

Mathieu Pagé

[Former Member]

Hi

You could consider setting the indicator, stop the replication and then start the replication without loading data (and dropping the target table).

That should be straight forward.

But I would also assume that you can run this program to modify the trigger after setting the indicator.

IUUC_REDEFINE_DB_TRIGGERS