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 vote and comment on it.

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

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

  • Hot ideas
  • Top ideas
  • New ideas
  1. It would be helpful if Source Control showed which branch is checked out currently.

    Before every commit I have to check in git if the selected branch is the appropriate. It's important and it would be easier, if SQL Source Control showed it.

    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…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Remove the Non-Standard filegroups warning

      When you create an object on a file gorup other than primary you get a warning message that you are using non-standard filegroups.

      This can be a little confusing since, in most cases the filegroups were crated and applied to objects for a specific purpose.

      Potentially replace with a warning that the non DEFAULT filegroup being used

      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…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • allow copy names from result Cell by Cell

        allow copy names from result Cell by Cell
        Like if we want to copy only object name it should allow.

        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…)
          0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
        • In Source Control commit changes tab

          it is nice to have a search criteria for each column on the grid result in commit changes tab

          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…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow filter rule changes to be undone or a filter to be enabled\disabled

            Changing a filter adds it to the commit tab, but the filter changes cannot be undone - which is a catch 22. If you ever want to undo filters so you can do some manipulation you should be able to undo these changes.

            So, the suggestion is either
            1. Add undo functionality on a filter
            or
            2. Add enable\disable functionality to filter

            I think undo should be there, because once it's in the commit changes tab there is no way out - unless you either unlink and link again or just commit or even worse, put the changes back manually

            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…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Allow user to disable dependant object refreshing

              When getting latest SQL Source control always tries to refresh dependent objects. We have a scenario where we _know_ we have broken objects (large database cleanup) and get latest fails because it tries to refresh those objects.

              Add an option where users can skip that step. It currently generates code like below:

              IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
              GO
              PRINT N'Refreshing [dbo].[v_SomeView]'
              GO
              EXEC sp_refreshview N'[dbo].[v_SomeView]'
              GO

              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 →
              • Add git support for migration scripts

                We use git and would prefer to not have to switch in order to use this tool.

                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…)
                • Bug: insufficient permissions when bringing database online

                  I have 60+ databases in my development environment, so keep all of them offline unless required.

                  If I bring a database online (using SSMS, right click, Tasks, Bring Online) SQL Source Control shows the error:

                  "Could not connect to the database. The database may be offline, or you may have insufficient permissions."

                  With the "complete error message" showing as...

                  "Cannot open database "xxx" requested by the login. The login failed. Login failed for user "xxx\xxx"."

                  I have access into the database, and can do anything I want with it - but the only way I can get SQL Source Control…

                  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…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Mark renamed objects, in particular sprocs, views, udfs

                    When using Mercurial linking, is it possible to add a feature to allow you to mark renamed object (in particular sprocs, views, udfs), so that the change history remains?

                    At the moment I am forced to use "Working Directory" so that I can save the changes and tell Mercurial that the object has been renamed.

                    Using the Mercurial link results in an added file and a deleted file and a lost of change history.

                    I realise there is already a completed feature for the renaming of tables to stop data loss, which can now be done with the Migrations (…

                    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…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • nr of rows column when adding static data

                      When adding static data from a large system it would be wonderful to be able to sort on a column stating how many rows the table contains!

                      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…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

                        We have thousands of tables (some with millions of rows) with only 90-100 static data tables.

                        At the moment, I have to edit the project; untick all then tick 90-100 manually which is very time consuming.

                        If there was some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

                        Thanks for your response.

                        Regards

                        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…)
                          3 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add ability to commit read-only files.

                          Almost half the time when committing changes I get error message
                          "Error Access to the path 'C:\User\UserName\Documents\Projets\Company\Dev\Sql\Tables\dbo.myTable.sql' is denied".
                          Since I cannot copy this folder path, i have to manually open Explorer and navigate to the destination folder one at a time. Once I change the file to not be read only I can then checkin the file.
                          Possible solution 1: Make it possible to copy the folder path in the error message so that it is much faster to get to the correct folder by simply pasting the path into windows explorer..
                          Possible solution 2: Give a warning that…

                          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 →
                          • Remove <Count> node under <DataFileSet> for static data files

                            Currently the RedGateDatabaseInfo.xml file has a node called <DataFileSet>, underneath which is a node (<DataFile>) for each table that is static data tracked.

                            The top node under the <DataFileSet> (before the individual <DataFile>'s) is a count of all the <DataFile> nodes below.

                            Can this count be done in the code?

                            I am forever solving merge conflict that are just that count node having the wrong value.

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

                              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…)
                                0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                              • Move sp_addrolemember scripts to be in User Object instead of Roles Object

                                In our System we have 2-3 predefined Roles that the application uses to run against.

                                The Issue I am running into is when scripting the roles i don't want all the sp_addrolemember being scripted into source control as the users using the role will be different in different environments. So it will always show up as a diff if the Role is already created and assigned to a user.

                                I would like suggest adding those sp_addroletomember scripts be configurable to be scripted in the User object they belong to instead of in the Role Object

                                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…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Change the icon in ssms for the tables that are linked as static data.

                                  When you link a table as static data in Sql Source control it would be nice if the static tables were easily identifiable under the tables node in management studio.

                                  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…)
                                    1 comment  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Provide a way to enter bugs

                                    Your feedback system should allow for a way for a user to input bugs that they find.

                                    For example, allowing unselect all for existing changes.

                                    I've never been a fan of SQL source control, and this product has made me dislike it even more.

                                    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 →
                                    • .AssemblyLoadHackery

                                      .AssemblyLoadHackery
                                      #1:We attempted to load RedGate.Update.Client, Version=2.3.0.237, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 3\RedGate.Update.Client.dll, but got RedGate.Update.Client, Version=2.3.1.308, Culture=neutral, PublicKeyToken=7f465a1c156d4d57

                                      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 →
                                      • Add Support for SVN Keywords $Rev: $ and $LastChangedBy: $

                                        Add the ability for SQL Source Control to update or make use of the $Rev: $ and $LastChangedBy: $ SVN Keywords

                                        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…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Allow filtering role membership the same as in comparison tools

                                          We do not source control database users, but we do source control database roles created and the permission sets granted to them. However, even if users are filtered, to check in the role we must check in role membership as well, which can change in the development environment, and is not the same membership we would want deployed to a downstream server

                                          0 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 →
                                          ← Previous 1 3 4 5 23 24
                                          • Don't see your idea?

                                          Feedback and Knowledge Base