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. Make SQL Source Control Options easier to access

    In order to access some options, such as enabling SQL Source Control in multiple instances of SSMS, you have to access a section of the setup tab that you can only get to after you have a database linked to a version control. This kind of thing should be available without having to go through all of that.

    As an example of where this comes into play, I open a local DB that I have no intention of attaching to SC and do some work. I then open another DB in another SSMS instance that I do want to deal…

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

      Thank you for the feedback. We are working on making the SQL Source Control global options accessible from the toolbar so that you don’t need to have a linked database in order to set them.

    • Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users

      Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users

      If it is there it will be very much helpful for most of the development projects not testing and production.

      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…)
      • Data warehouses need source control too! (Azure SQL Data Warehouse / PDW)

        Add source control support for Azure SQL Data Warehouse. I'd love to be able to source control my data warehouse schema.

        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…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • 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 →
          • history rename

            Treat object RENAME as Source Control (TFS) file RENAME not Drop & Add which deletes Source Control history of the object/file

            More details can be found here: https://redgatesupport.zendesk.com/hc/en-us/requests/88809

            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…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Keeps detecting changes for value s'

              Hello,
              I have a table with only one PK column of type nvarchar(200) which contains static data.
              Source Control keeps telling that there are changes even after saving the changes. It seems that it has some issues with the value s'

              Database version:
              -- Only In Database

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')

              -- Identical

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan')
              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan de')

              Latest source control version:
              -- Only In Source Control

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
              -- Identical

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
              INSERT INTO [dbo].[tab_54_Voorvoegsels]…

              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 →
              • Ability push database linking of database to team members

                When using a shared database development model having a location which allows you see which developers have linked to the database. Also having the ability to be able to push out the linking to the database to developers from a central point

                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 →
                • A way to select the database from the tab itself.

                  I develop and have to switch between multiple databases and the source control tab keeps following the database I am on. When I want to commit changes I have to stay put otherwise I keep losing the progress looking for changes. It would be nice to have the option of which database we are looking at from the tab itself, instead of from the SQL Management Studio one

                  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…)
                  • Bad truncation warning message when resizing fields from small to large size

                    A truncation warning should only be given when a field is resized from large to smaller, where actual truncation could occur. Not from small to large where truncation would not occur.

                    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 →
                    • Only show application files in MRU

                      The "recently used" lists for both SQL compare and SQL data compare show files for both applications. I find this very confusing, as I have quite a lot of files for both and I have to keep reading the extension to know whether this is a SQL Compare or SQL Data Compare file.

                      Could we have an option to have a separate "recently used" list for each application, so that I don't see SQL Data Compare files when opening SQL Compare, and vice versa?

                      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  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                      • Uncommited change wall of shame report

                        Button to produce a wall of shame report of uncommitted changes by user across all databases

                        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  ·  Flag idea as inappropriate…  ·  Admin →
                        • "error creating window handle"

                          Redgate is throwing an error that is costing a lot of our time to be wasted. I can link to source control no problem, but when I go to the commit tab, I see steps 1 through 4/4 complete, then I see the list of changes to check in, but this error pops up and after submitting the error report, the list of changes disappears. I have tried a lot of things and cannot get it to work. Here is what I tried:

                          Unlink redgate
                          Close SSMS
                          Delete entire directory -> C:\Users\AlbersM099\AppData\Local\Red Gate\SQL Source Control 5
                          Restart computer
                          Open SSMS …

                          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  ·  Flag idea as inappropriate…  ·  Admin →
                          • require a commit message for git

                            Git requires a commit message by default however SQL Source Control circumvents this setting and commits without a message. There are a few other submissions attempting to get this fixed which have been declined. Seems you are missing the point.

                            In the case "Empty commit message for git is invalid" the very article you've linked points out that it takes special command line flag to commit without a message. SQL source control commits without a message and provides no mechanism to prevent this. There is no configuration for git that will do this because the default git behavior is already…

                            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…)
                            • Keeping history of locked and unlocked objects

                              Locking feature doesn't keep history of who has locked or unlocked specific objects in database. This could become useful when a person unlocks an object locked not by him/her and would help to track historical changes.

                              It would require very few changes - additional history table,

                              [SQLSourceControl].[LockObject] and [SQLSourceControl].[UnlockObject] procedures would have to be modified.

                              Possibly an additional view to see that data in SQL Source Control instead of selecting raw tables.

                              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  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                              • Use JSON as a data source

                                from http://country.io/continent.json you can have both countries to contenents and give Countries valid cities eg http://country.io/capital.json Which means if you can defined a key-value pair you can create more accurtate test data that placing "St Petersburg" in "Iceland" which is the current option.
                                At worse if the json file was downloaded and 'mounted' as a table would be useful. But really JSON is the new datasource that Red-gate has to connect to.

                                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 →
                                • Connections to server

                                  With Amazon RDS, the server names are changed each time an instance is created. If a dev instance is recreated monthly, and a testing instance is recreated daily, it is impossible to keep the connection to source control when the server names change.

                                  The only way to get source control to work with our system is if it were able to connect to a static end point (dns record) rather than the server name itself

                                  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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Source Control Standalone instead of SSMS snapin

                                    Source conrtol should be a standalone app not SSMS addin. When performing get latest or commits, on large environments and slow connections this can easily take 20 minutes during which a click anywhere else in SSMS restarts the get latest/commit process. The logical use of source control being a SSMS addon has been outlived.

                                    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…)
                                    • SQL Compare and SQL Data Compare Deployment Script - Static Name

                                      When using either SQL Compare or Data Compare, during deployment, can we have an option to supply and store a static name for the script file rather than having to overwrite script file name in each deployment. You could supply an option to automatically overwrite the file. For early development I want one script only, I don't need to maintain a history, especially if I'm going through the deployment testing phase.

                                      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 →
                                      • SQL Toolbelt Installation/Product Manager - Control Panel

                                        It would be great if we could have a product manager for SQL Toolbelt and or individual products we're licensed for. In the manager you could see which products you have access to, which ones that are installed, view the VS and SSMS versions installed in your local system and install/uninstall products to the VS and SSMS versions. This would be similar in operation to the Telerik Control Panel which provides this kind of functionality.

                                        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…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Creating database from scratch on linux

                                          I have a bunch of Ruby services which talk to sql server. I'd love to be able to stand up and tear down databases for development using Microsoft's mssql-server-linux docker container while still managing my database via Redgate. This would require a linux-based CLI tool that could create the database from source.

                                          To do this would require a linux-compatible container

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

                                          Feedback and Knowledge Base