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?