Exlcude specific items from Deploy script from Comparison Results screen
SQL Compare
Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.
This is a SSDT feature that is missing in SQL Compare.
I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.
Using a trigger associated as with a table as an example:
Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger on the source should not be copied to the target, but other schema changes on the table should be copied.
In the comparison results screen - allow an action on the row for the modified table to exclude the trigger from the deploy script.
The resulting deployment script would simply exlude the trigger from update.
A more shophisticated choice would be "preserve". This would exfectively keep the target definition (if it exists) - a choice required is a table rebuild is required.
The existing filters panel should not be affected by this (beyond reflecting the resulting filter rule from the exclusion made on the table).
-
Daniel Mills commented
Having triggers dependent on the table object doesn't really consider that sometimes we may make a trigger change that lasts longer than the sprint and a table change needs to go without it. Having them as separate object types alleviates this issue.