More granular control of filtering & scripting

philsayersphilsayers Posts: 2
edited October 3, 2006 4:31PM in SQL Compare Previous Versions
I would like to see the ability to filter and script at a more granular level.

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.

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
    Daniel Handley
    Red Gate Software Ltd
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    You can script individual objects (including triggers) using the Work.ScriptObject() method in SQL Toolkit code.
This discussion has been closed.