How can we improve SQL Source Control?

Display the server name in the "SQL Source Control" Setup window.

Someone in my team linked one of our test environment's databases to his source control. He was in a feature branch and just performed a "Get Latest" on the dB..... Now we have to reimplement the integrated changes. Please display the Server name in the setup window to avoid confusion and make sure this is clear.

3 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…)
    MarkMark shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    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...
      • CJ ButcherCJ Butcher commented  ·   ·  Flag as inappropriate

        YES!!!! This is a MUST have change! I was just going to suggest it too. Saw this comment and the response.
        Why is it a manual configure thing? I would bet that most people have the same database names in live/test/dev environments so making it the default seems like the "Smart way to go".

      • Adrian BanksAdminAdrian Banks (Admin, Redgate) commented  ·   ·  Flag as inappropriate

        You can already set an option to show the server name along with the database name, but you have to manually set it in a configuration file.

        In %LOCALAPPDATA%\Red Gate\SQL Source Control 5\RedGate_SQLSourceControl_CommonUI_UIOptions.xml, add a new element:

        <ShowServerNameOnTabs>True</ShowServerNameOnTabs>

        You will need to restart SSMS once you have saved this change.

        This will cause the server instance name to be shown in addition to the database name throughout SQL Source Control.

      Feedback and Knowledge Base