How can we improve SQL Source Control?

Fix bug with role members and schemas

I filter out database users in my source control, because I do not want them accidentally deployed to another environment (may not be consistent across all environments). However, I do source control database roles, as many required permission sets are maintained through these roles. However:

1. Currently it is not possible to check in a database role without also adding the role membership. This should be a configurable option.
2. When using SQL Compare to deploy from source control, each user that is a member of a source controlled database role shows up as a "Schema" not present in the target database

7 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…)
    Timothy BattsTimothy Batts 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...

      Feedback and Knowledge Base