Disabling triggers
JohnStodden
Posts: 3
I am evaluating Data Compare 8. I have 2 tables with insert and update triggers. Obviously I find I need to delete these before running the sync, and restore them when the sync is complete.
Is there any way of automating this?
thank you!
Is there any way of automating this?
thank you!
Comments
Thanks for your post. If you go into the Options from the Project Configuration screen you should see options for disabling DDL and DML triggers. These will of course also be re-enabled upon successful synchronisation.
Is this what you are after John?
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569