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. fails on more than 200 objects

    I have about 800 objects. I can only add 100 to 200 objects at one time. If I try to add too many it fails.

    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…)
      2 comments  ·  Flag idea as inappropriate…  ·  Admin →

      This sounds like a problem we’ve seen before. Do you have Microsoft Security Essentials installed? If so, this could cause a problem when committing a large number of objects, which is usually the case when first committing an existing database to source control. Your workaround of doing a smaller partial commit seems to fit this expected behaviour.

      To get around this, please configure Security Essentials to exclude LOCALAPPDATA\Red Gate\SQL Source Control 0\ from live protection.

    • No whitespace in file/directory names

      I want an option for all scripts and directories to have no whitespace in their file names. For example "Database Triggers" would be "DatabaseTriggers". This makes working manually with the scripts from the command line much easier.

      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…)
        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
      • Provide ability to merge a conflicted object, instead of just Keep Mine or Take Theirs

        I have seen no way on how to actually do a merge with SVN and mark as merged etc
        We really need a more inutuitive way to merge the changes to SVN and vice versa. At the moment I am getting conflicts that I can't put into SVN because there is no way to say it has been merged, or even how to merge the changes.

        81 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…)
          10 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Foreign Keys scripted in different order each time table is edited

          I've found that frequently when I change something about a table (add a column for example), then when I do a diff of that table from SQL Source Control before checking in, the diff shows that the order of the Foreign Keys has changed. For example, it might list FK_1, the FK_2, and then FK_3 on the left side of the diff, and FK_2, FK_3, and then FK_1 on the right side of the diff. The definitions of the foreign keys have not changed, just the order in which they're scripted. So, this is not a critical issue, but it…

          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…)
            1 comment  ·  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 →
            • Bug? Function type detection seems unreliable

              I'm having problems retrieving a recursive table-valued function from SVN so I tried to do it manually in stages which didn't work because SQL Source Control kept attempting to drop the function and then recreate it.

              The steps I followed were:
              1. Refresh the get latest tab and copy the function from the differences window.
              2. Paste that SQL script into SSMS
              3. Remove the part of the function that does the recursion (the second half of a UNION so the return type is still the same)
              4. Execute the script to create the object
              5. Get latest from SQL…

              1 vote
              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  ·  Flag idea as inappropriate…  ·  Admin →
              • Open object's script file from Source Control

                When I link a database to source control (TFS), and then open an object from the object explorer I would have expected the file script in source control to open in the management studio window. Instead it simply scripts the object from the database server. I don't think this is really sql source control, it seems more like a polished deployment engine.

                When a database is linked to a TFS source location, it should open the TFS file no matter what you do in the object explorer.

                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…)
                  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to generate changes to file locally so we can manually commit with other changes

                  I would like it to update the files but not commit as I generally like to commit a set of related changes together.
                  i.e. chaning the database schema and an on screen form to display new columns, they should appear as one commit. Currently I have to do two seperate commits

                  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…)
                    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Select first difference automatically

                    On the Commit Changes tab, please make it show the first difference in the compare pane.

                    This is particularly helpful where object permissions are changed often, as it becomes a pain to review a list of otherwise unchanged objects that just have new GRANTs on them. An alternative would be to show permissions as a separate entry to the object.

                    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…)
                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →

                      Did you know? The “Next” button at the top of the diff pane will jump to the next difference in the script. This may help you jump right to where the first change is for now.

                    • Make the SVN URL case insensitive

                      It would be easier if the SVN URL that I entered was case insensitive.

                      1 vote
                      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  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add ability to associate check ins with Work Items in TFS

                        Visual Studio already allows this which keeps track of which Source Control items go with which Change Control items. This would also be greatly beneficial if we could associate the database changes as well.

                        129 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  ·  Flag idea as inappropriate…  ·  Admin →
                        • Diff panel doesn't save the text size

                          When i change the diff panel text size and reopen the management studio, the text is not the size i have previously selected. Some other options (line numbers) doesn't save too.

                          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…)
                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Ability To Script Indexes and Foreign keys as seperate object scripts

                            It would be nice to be able to script indexes and foreign key constraints as seperate object scripts as the table columns may not change but may have additional indexes.

                            44 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…)
                              3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Get specific version from source control (SVN: Update to revision)

                              Instead of Get Latest, I want to be able to get a specific version out of source control and reapply it to the database. This would allow me to rollback changes that were accidentally committed. I should be able to specify what version/revision that I want to go back to.

                              This is the same as getting a previous version from source control so that I can debug an issue a user found in a previous release.

                              177 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…)
                                10 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                We are considering this feature as a candidate for SQL Source Control 5.

                                You can still work around this by using SQL Source Control with SQL Compare Pro. Just highlight the specific version in the history that you want and click the “Update to this version using SQL Compare Pro” button.

                                A free trial of SQL Compare Pro is available at http://www.red-gate.com/products/SQL_Compare.

                                The SSMS Integration Pack, which comes with SQL Compare Pro also allows you to deploy directly from SQL Source Control repositories.

                              • Square brackets

                                Please add an option to script the database objects with square brackets around the object names. The Microsoft Management Studio Scripts include Brackets around the object names when they are scripted. So, if an objects is scripted from SSMS then run against the database it show up as being different in Source Control because the brackets were included in the SSMS script. Of course, you can manually remove the brackets before running the script but this will be cumbersome. I know that using the file that has been checked into SVN is another work around but we all know that…

                                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…)
                                  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Error during applying changes to live DB

                                  The error should consist more detailed data. Like from which procedure, function or table such error was thrown. I assume my error has nothing to do with SQL Source Control, it's my DB ;)

                                  1 vote
                                  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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Get to an object's properties from the "Commit Changes" tab

                                    It’d be cool if from the “Commit Changes” tab you could get to the objects properties or at least get it selected in the Object Explorer, maybe from a double / right click?

                                    4 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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 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…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 71 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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Support SSMSE (SQL Server Management Studio Express)

                                          I can't install because I am forced to cancel the installation. It refuses to install because it says SSMS is required... while I have SSMSE installed.

                                          4 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  ·  Flag idea as inappropriate…  ·  Admin →

                                            We currently support SSMS 2005,2008 , and 2008 R2 connecting to SQL Server 2005, 2008, or 2008 R2 databases. (We currently do NOT support any SSMS Express editions.)

                                          • Don't see your idea?

                                          Feedback and Knowledge Base