Options

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!

Comments

  • Options
    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?

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