What are the challenges you face when working across database platforms? Take the survey
Options

Ignoring triggers

krinamankrinaman Posts: 2
edited July 31, 2007 6:06AM in SQL Compare Previous Versions
Is there a way to ignore triggers that are only on the updated database.

For example:

I want to update a database (I call it copy) to match another database (we can call source). This database contains a table (MyTable) that has two triggers (MyTrigA and MyTrigB) on the source database but has three triggers on Copy (MyTrigA, MyTrigB, and MyTrigC). What I am looking for is a way to update MyTable on Copy without deleting MyTrigC but updating MyTrigA and MyTrigB if they are different.

Is there a way to do this?

Comments

  • Options
    Hi there,

    you can use the option 'Ignore DML triggers'. This will cause SQL Compare to ignore any DML triggers when it is comparing and synchronizing your tables.

    Regards,

    Tom Harris

    Red Gate Software
Sign In or Register to comment.