How can we help you today? How can we help you today?

Enhancement Request - Triggers

We make extensive use of table triggers for our own devised replication and data synchronisation. Some of our databases require these triggers present whilst others do not.

It would be extremely useful to be able to view these triggers seperately from the Table, so that we can choose whether to synchronise the triggers; and indeed to be able to generate change scripts for the triggers in isolation. :wink:
GavinJohnson
0

Comments

2 comments

Sort by
  • JonathanWatts
    Gavin,

    Thanks for your comments, there is a movement growing behind this feature, so I think it is going to be one that we are going to have to include in future releases. Sorry, but we just don't have the time in the schedule right now to do this for v6.0.

    Regards,

    Jonathan
    JonathanWatts
    0
  • -M-
    Count me in on that movement!

    At a slightly broader level...

    When viewing schema differences, you have the option of viewing the T-SQL in groups (columns, constraints and indexes, triggers, etc.). Wouldn't it be great to see the same functionality in the base window brought down to this? For example, right-click on the triggers section and say "exclude all items" just like I would for one of the sections above. Or maybe I uncheck the box next to "Trigger4" while leaving the other triggers checked.

    Man, that would be cool. This of course would be in addition to the global options of "ignore triggers", etc.

    Just a thought.
    -M-
    0

Add comment

Please sign in to leave a comment.