i have a trigger on a table that runs when a new row is inserted or modified. how do i filter only this trigger out of the comparison (leaving the table in the comparison)?
There are a number of options in SQL Compare revolving around ignoring triggers, however they are only able to do this en masse and not for individual triggers on tables.
This is however currently in our systems under feature request SC-2447.
Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Comments
There are a number of options in SQL Compare revolving around ignoring triggers, however they are only able to do this en masse and not for individual triggers on tables.
This is however currently in our systems under feature request SC-2447.
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
hopefully it will be released in SQL Compare vNext
I couldn't possibly confirm if it is going to make it into a future release, however I am sure that it will be reviewed.
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569