Comments
2 comments
-
Hi
Unfortunately we have based all the differences around objects in SQL Server and triggers and indexes are associated with these objects rather than in their own right.
However if you create your own application using the toolkit I believe that you can script individual items just as you require.
Regards
Dan -
You can script individual objects (including triggers) using the Work.ScriptObject() method in SQL Toolkit code.
Add comment
Please sign in to leave a comment.
eg: choose to only script changes in triggers, rather than having a change in a trigger mean that that the 'table' is different....just show that a 'trigger' is different....same for indexes.
Would like to see more control over the script generation headers and footers...wrapping or not wrapping the while thing in a transaction, choosing the SET options the include or not include in the scripts.