Ignoring triggers
krinaman
Posts: 2
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?
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
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