How can we improve SQL Source Control?

The undo feature automatically disables your database triggers. I don't want my database triggers disabled.

We use DB triggers to track schema changes. If we use the Undo feature, it disables the triggers and we no longer are able to record the history apart from our source control system. Source Control is great, but we need to know exactly who made changes and when.

2 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Chase JonesChase Jones shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • James BillingsAdminJames Billings (Admin, Red Gate) commented  ·   ·  Flag as inappropriate

        Normally, if our engine has to disable triggers during an update, it should re-enable them afterwards again. The Undo option will basically update your DB to the copy from the repository- if the object you're updating has a trigger on it in the repo, that should survive intact after the undo process. If, we're disabling triggers on related objects to the one you're undo-ing, and not re-enabling them afterwards, that sounds more like a bug, and a specific example would be useful.

      Feedback and Knowledge Base