Settings and activity

  1. 10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control » History/Log  ·  Flag idea as inappropriate…  ·  Admin →

    We have been working on v2 of Migrations, which stores migrations scripts in a table valued function within the database. This table valued function appears in the history. An Early Access Release of SQL Source Control is now available and can be downloaded from http://documentation.red-gate.com/display/MV2.

    NOTE: This is an Early Access Release and is not fully tested or functionally complete yet. It would be great if you could try it in a test environment and let us know about your experiences so we can fix any issues and try to make any updates you need before the full release.

    Thank you!
    Stephanie Herr :-)
    SQL Source Control Product Manager

    Pete Cousins supported this idea  · 
  2. 9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
    An error occurred while saving the comment
    Pete Cousins commented  · 

    We always filter users as there are different users in different environments. We have problems when developers forget to do this. This improvement would be great.

  3. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  4. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control » Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
    An error occurred while saving the comment
    Pete Cousins commented  · 

    This would be great. We always Ignore 'Users' permissions and role memberships' as users in live, test and UAT are different. We get into difficulties when we don't

  5. 18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  6. 25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  7. 35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  8. 43 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  9. 125 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    17 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Richard Macaskill responded

    The latest release 1.6.2 of DLM Dashboard now supports up to 50 database,

    Note: Previous status update was an error.

    Pete Cousins supported this idea  · 
  10. 158 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  11. 10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  12. 17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard » History  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  13. 49 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  DLM Dashboard » History  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  14. 189 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pete Cousins commented  · 

    We created tags in SVN when creating a release. Much simpler than using revision numbers.

  15. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins supported this idea  · 
  16. 19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Pete Cousins shared this idea  · 
  17. 38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pete Cousins commented  · 

    If you're using database roles to control permissions to objects, this abstracts the permissions somewhat. However SCC includes the list of users in the role. Currently the only way around this is if the role is excluded from SCC. Personally, as a DBA, I prefer the permissions to be in SCC, as it's up to the developers to decide who should have access to what objects.

  18. 477 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    31 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Kendra responded

    Thank you everyone for your comments and votes on this over the years. While I don’t have a 100% full resolution for this suggestion, I can sum up our current recommendations here. Continued feedback is very welcome.

    Our current recommendation is to use the post-deployment script feature of SQL Source Control (released in V6.3) to manage SQL Server Agent jobs.

    An example script for this is here: https://documentation.red-gate.com/soc/common-tasks/working-with-pre-post-deployment-scripts/create-sql-server-agent-job

    As some commenters in this thread have alluded to, it is possible (and sometimes very common) for SQL Agent jobs to have steps that touch multiple databases on a single SQL Server Instance. For this reason, some customers prefer to create a separate database for instance-level management and objects (sometimes named DBA or similar) and choose to manage things like linked servers and SQL Agent jobs with the post-script associated with that database.

    This separate-database architecture also makes sense if the jobs…

    Pete Cousins supported this idea  ·