Disabling triggers

JohnStoddenJohnStodden Posts: 3
edited February 11, 2011 4:19AM in SQL Data Compare Previous Versions
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!


  • Hi John,

    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?

    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • That seems to do it. Thank you!
Sign In or Register to comment.