SQL Source Control

Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.

If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.

To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

How can we improve SQL Source Control?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. initial setup automation

    We've got HUNDREDS of databases. Dozens in active development.
    Several obvious details are missing from the initial setup of a linked database. These are specific to VSS, but I'm sure apply to other SSC versions:
    1) Remember the last used (VSS) Database path.
    2) Remember the last Source Control Folder, BUT... SUGGEST the name of the new DB as the terminal project name.
    3) Add a Check box to "Auto Commit" ALL objects.

    The amount of retyping (or even copy/paste/edit) the same information over and over is quite annoying.

    136 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…)
      29 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →

      I wanted to update this as some recent testing has shown we broke the workaround for this a while ago. We are however scoping out what it’d look like to solve this properly. We have many of your contact details, so will be reaching out to a few of you for help, but if you’re super keen to get involved feel free to post above or email me and we’ll get you involved.

    • Red Gate Source control should only need one workspace

      Red Gate Source control should only need one workspace. Is there a specific reason Red Gate creates multiple workspaces per database linked? This is creating a mess of my workspaces.

      51 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…)
        5 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
      • Centralized uninstaller

        I had to uninstall RedGate SQL Toolbelt today, and this involved uninstalling 13 separate products individually. It would be nice if the easy installer could uninstall just as easily.

        (So you aren't disappointed that I uninstalled: I was switching over to the MySQL tools.)

        48 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…)
          9 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →

          We’re looking into having a centralized uninstaller currently – I’ll update when we have more details.

        • Allow include Identity option at table level instead of Database level.

          In many databases there few tables with static values which are mapped with enums in the code. For such tables, Include Identity columns option is required. However, for few tables, we may not require to maintain the same primary key value in the source and target DB. Please do the needful

          26 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…)
            0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
          • High DPI screen scaling doesn't work well with SSMS 2016 RC3

            High DPI screen scaling doesn't work well with SSMS 2016 RC3.
            The source control screen doesn't fill the entire work area, but just takes up a small rectangle in the top left (approximately 50% x 50% of the work area).
            This occurs on a 3840x2160 pixel screen, SSMS version 13.0.14000.36, red gate source control version4.4.0.1714 standard

            21 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…)
              4 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
            • Source control slow down

              SQL Source control is slowing down my entire SSMS. This wasn't always the case, but now trying to get a context menu to show up on a table can take up to 30 seconds. Please fix!

              14 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…)
                1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow linking to system databases

                I don't think this suggestion is here already, apologies if it is! I would like to be able to link system databases (esp master) to source control as my company has a number of shared procs here. The ability to optionally exclude the normal system procs when extracting would be really useful.

                12 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…)
                  7 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                • If I exclude items from source control they should not default to be committed due to dependencies.

                  If I exclude items from source control they should not default to be committed due to dependencies. It would be great if there was a setting when items are excluded to never include them in the list of items that are dependencies.

                  11 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…)
                    2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add a button to "Unlink, Delete my cache, Relink" so when support asks you to perform that function, it just takes the user 1 step.

                    Add a button to "Unlink, Delete my cache, Relink" so when support asks you to perform that function, it just takes the user 1 step.

                    10 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…)
                      0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                    • Unable to connect to the Redgate Client Service.

                      'Please ensure that the service is started. Click here for more information about this problem.'
                      How about fixing this bug for when source control have forgotton its lic, which of course is fine . you can then try deactivating and reactivating, it says its is ok but nothing has changed. Would be so nice to be able to log on to your subscription, and tell it 'USE THIS ONE' so it can see on a redgate site what lic to use.

                      10 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…)
                        1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                      • Rife with Out of Memory Exceptions.

                        So, I install the tool to use with a real-world database of 1GB. And all I get are Out-of-Memory exceptions when trying to add data. Or even just run the tool. This is one of the worst software experiences that I've ever had!

                        Did I just get a buggy version? 3.0.13.4214

                        9 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…)
                          5 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                        • Use windows username instead of disaply name for linking to TFS 2012

                          I am unable to link databases to TFS 2012 due to our parent company enforcing a Active Directory display name of "LastName, FirstName" which TFS claims is invalid due to the comma.

                          It is a known issue with TFS (http://connect.microsoft.com/VisualStudio/feedback/details/768112/tfs-2012-build-failing-with-tf10158-user-name-contains-unsupported-characters)

                          The workaround listed on Microsoft Connect is to use "domain\username" instead of display name when sending commands to TFS. Unfortunately, SQL Source Control doesn't expose a way to do this currently.

                          8 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…)
                            0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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.

                            6 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…)
                              2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                            • TFS integration should allow you to select which workspace to use

                              TFS integrations really needs you to specify which workspace you are working with. This does wrong right from the start - when I try to link a database to TFS, it asks for the source URI and data folder, but it will only accept data folders already checked in, not that I have created in my workspace.

                              6 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…)
                                4 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                              • Set default options for comparison

                                Allow use to set default comparison options e.g. <AddDatabaseUseStatement> rather than have to do it for every individual database linked.

                                6 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…)
                                  1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                • Include miscellaneous options / database properties

                                  SQL Source Control tracks options like Default Collation. It would be useful to extend this to include all options that can be configured e.g. Recursive Triggers.

                                  6 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…)
                                    1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                  • installed toolbelt this morning, uninstalled this evening due to SSMS UI impact...

                                    I am completely put off by Redgate taking over so much SSMS UI. I was very attracted to some of the tools, but can't work like this. Tried to find way to disable/hide them, but appears uninstall is only way.

                                    I want minimal UI intrusion until such time as I decide I like/want more UI intrusion. We need a way to dial it back to point where all redgate stuff optionally sits under single top menu and/or context menu.

                                    I reckon in meantime I will install tools in a throwaway VM so I can see how they work without impeding…

                                    6 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…)
                                      1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Do NOT show SQL Source Control tab when starting SSMS

                                      SQL Source Control tab should NOT be the DEFAULT on SSMS startup, Object Explorer Details should be the tab selected.

                                      6 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…)
                                        2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                      • ignore constraint table default

                                        Separate edit filter rule to ignore constraint names that define a default value for a column

                                        5 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…)
                                          0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Copy Filters between databases, or have a standard Filter template.

                                          I would like to be able to copy the Filters to different databases, or have a Filter template which I can save to apply to other databases. There are many objects which I do not want to be moved from Development, QA, Integration and Production. Currently, I generated the XML using a query with sys.databases and saved it to DifferenceFilters.xml which is a pain.

                                          5 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…)
                                            0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base