How can I Ignore Table Triggers

BuckBuck Posts: 2 New member
in SQL Compare
I have some databases that are using Symmetric and the triggers vary by server due to an ID in the Trigger itself.

How can I ignore trigger differences?
Tagged:
· Share on Twitter

Best Answer

  • adam_hafneradam_hafner Posts: 88 Silver 2
    Answer ✓

    Yes, you can do this in the Options screen of the Project you setup.  There is an option to 'Ignore DML triggers'  I do not see an option for ignoring DDL triggers though, but maybe DML is all you need?

    · Share on Twitter

Answers

  • BuckBuck Posts: 2 New member
    I ignored both the DML & DDL triggers and reran it.
    One or the other seemed to work but if I just run with 1 it didn't seem to.
    Not sure why.
    · Share on Twitter
Sign In or Register to comment.