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. Exporting Multiple Tables from the results pane to seperate Excel Tabs

    The open in excel feature is impressive and I love to use it for ad-hoc extracts. Having the ability to extract multiple results in 1 go to a single Excel file with different sheets would be great.

    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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
    • SQL Source Control need to recognize SQL 2016 code

      Currently SQL Source Control is crashing when SQL 2016-specific code is used, for example:
      DROP TABLE IF EXISTS #input;

      It should recognize this code since SQL Server 2016 works with it.

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

        This is caused by the SQL Compare parser not understanding this syntax. The good news is the SQL Compare team are currently working on SQL Server 2016 parser support. Once this work is done and SQL Source Control is updated with the latest SQL Compare engine, I will update this request again.

      • Global Filter by Schema should exclude Schema Object with same name

        This filter should exclude an object with a schema that has a matching name.

        -- All Objects

        Exclude where (@SCHEMA = 'tSQLt') OR (@SCHEMA = 'SQLCop')

        Did not exclude this schema object definition.

        -- Schema

        CREATE SCHEMA [tSQLt]
        AUTHORIZATION [dbo]
        GO

        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 →
        • Add a "Covered by Migration Script" option to the commit tab

          When committing changes it would be nice to be able to mark changed items as "Covered / Included in existing migration script" so that they are not checked into source control. I am specifically talking about uncommitted schema changes. For example, transferring a table to a different schema. SQL Source Control sees this as a drop (from old schema) and create (in new schema), but there are times when it should be an ALTER SCHEMA statement in order not to lose the data from the table. The ALTER SCHEMA can be added to an existing migration script instead of creating…

          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…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Support Azure Active Directory Authentication

            This has over 50 votes but its in SQL Prompt. This is a HUGE pain for us as we need to use AD to adhere to security policy.
            https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/15008409-add-support-for-azure-active-directory-authenticat

            36 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 →
            • Decrease size of UI on HiDPI/4K displays

              If you have a HiDPI or 4K display, SSMS is scaled to 2x. In SQL Source Control, The Commit and Get Latest tabs are fine, but the Migrations, Locking and Setup UI are scaled MUCH larger than 2x. I would prefer those UIs be scaled to 2x.

              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…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Make columns resizable on Migrations tab

                It is not possible to resize the columns on the Migrations tab. This makes it difficult knowing which objects to include when creating new migration scripts as most of the names are truncated.

                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 →
                • 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 →
                  • Locking/unlocking functionality

                    Get rid of the option for anybody to unlock an object, but instead allow to unlock only by the person that locked the object or by a group in group role in the database where only few people have access.

                    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…)
                    • From the Source Contol tab, it should be easy to tell which instance you are updating.

                      Sometimes I'm connected to multiple instances and it would be nice if the Source Control tab made it clear which instance I was about to change or commit from.

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

                        SQL Source Control needs a history view, to be able to view historical Commit/Get updates. A simple list of when/who etc then the ability to see the script used?

                        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  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                        • Support unicode characters in data scripts Arabic for example

                          When linking static data to source control the unicode characters are appearing as question marks
                          so please add the support for the unicode characters in the script files

                          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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                          • Enable merge button also on "unresolvable conflicts"

                            Merge conflicts cannot be resolved if both users commit and one of them pushes.

                            To reproduce this behavior:
                            1) user A performs a change on a line of a SP
                            2) user A commits and pushes
                            3) user B performs a change on the same line of the same SP
                            4) user B commits
                            5) user B tries to pull and a message says conflicts must be resolved outside SQL Source Control and it is also impossible to push (please see the attached screenshots)

                            Only if user B performs step 4 after step 5 it is possible to see the…

                            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 →
                            • Track changes as Git does / Support Git reset --soft

                              It would be really nice if SQL Source Control allowed commit undo like git reset --soft or tracked the filesystem as Git does instead of tracking commits.

                              Scenario that highlights this unexpected behavior:
                              - perform some changes on the DB
                              - commit changes
                              - perform a git reset --soft from command line (undoing the commit while keeping changes on the DB and file system is not possible from the SQL Source Control UI)
                              - if further changes are performed from the UI it is possible to commit current changes (old + further changes), but if SQL scripts are changed directly,…

                              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 →
                              • Full support of Git branch from SQL Source Control

                                It would be nice to be able to create and checkout a branch form the SQL Source Control UI instead of having to switch to the VCS client.

                                53 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  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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 →
                                  • Auto-refresh the changes to commit icon

                                    The blue circle indicating changes to be commited should auto-refresh (added/removed when necessary) and refresh when the SQL Server refresh icon or menuitem are clicked.

                                    Now it only refreshes when the user goes on the Commit or GetLatest tab.

                                    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 →
                                    • Cannot create migration script for selected changes in the newest version

                                      Using the latest verrsion I cannot create a migration script for selected changes (checkins in the versioning control system).
                                      The menu option it had in the database context menu is missing.
                                      Why did you remove this feature?
                                      It was nice for allowing migrating environments that you cannot connect to.

                                      34 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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Support GIT hosted under TFS

                                        We use GIT hosted under TFS in order to use Windows authentication to protect the GIT repositories.

                                        SQL Source control does support a local copy of the GIT repository but remote Push and Pull fail in SQL Source Contrtol 5 because it cannot handle the login dialog needed to get to GIT

                                        172 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…)
                                          14 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Integrate Get Latest in SQL Source Control With DLM

                                          When doing a Get Latest in SQL Source Control, if database is registered in DLM, then register the known schema from SQL Source Control

                                          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 →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base