SQL Source Control

Thank you for evaluating SQL Source Control. Your feedback will impact what we do next!

Suggest a new feature or enhancement; Ask a question...

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. Exclude/Include filter not working as expected, SLOW performance

    we have 13000 objects in our database.
    12800 of them are all in the dbo schema which contains the standard logic for our product.
    The rest 200 are in the customer specific schema.
    We are not interested in source controlling the standard logic, since we get it from our supplier.
    We need to source control our customer specific changes. For that every change is made in another schema.
    We can perfectly filter the objects out for source control with your tool.
    (so they do not appear on the commit screen). However it is very very slow, that's why I suspected…

    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 →
    • Cannot Get Latest

      Everytime I try to Get Latest I get the following....

      System.Exception: Failed to update to the head revision after 10 attempts ---> System.Exception: Failed to update to the head revision after 10 attempts
      at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetDatabaseFolderWorkspaces(ICancellableOperationStatus status, IScriptFolderStructure scriptFolderStructure, IReadOnlySourceControlServerCallBacks callBacks, SourceControlRevision& revision)
      at #GWeb.#WXM.#Fieb()
      at #GWeb.#Wheb.#tieb(Func`1 )
      at #GWeb.#WXM.#8ZW(Boolean )
      at #GWeb.#XXM.#yRW()
      at #GWeb.#WXM.#qYM()
      at #GWeb.#XXM.#iS()
      at #qlhb.#0heb.#l36(String , #1heb , ICancellableOperationStatus )
      at #qlhb.#K3c.#83c(String , #O9U , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
      at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#A3.#eL5b(ICancellableOperationStatus )
      at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#jzb.#Qnw()
      --- End of inner exception stack trace ---
      at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#VAb.#xSXc()
      at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action ) …

      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…)
      • For shared development environment, replace "GET ALL" with list of historical changes made

        When developing in shared enviroment, I'd love a history tab that I can review all revisions with details, and not have to have a modal window separately. I believe this should be integrated into the main source control tab as change history log. This could help make others aware of changes made that could affect them, yet were already committed. Thanks!

        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…)
        • When opening SSMS show all databases with differences in the Object Explorer view without having to select each individual database

          When opening SSMS highlight all databases with uncommitted changes in the Object Explorer view without having to select each individual database.

          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 →
          • On conflict when commiting changes able to right click and open proc/table in new sql editor

            When you get conflict when commiting changes it would be nice to be able to right click and open proc/table in new sql editor, do you change (merge) and continue.

            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…)
            • On shared mode, Source control sync delayed issue

              Shared mode is perfect for small team DEV environment, but status update delayed to sync is annoying....is there a way to config the sync frequency?

              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…)
              • Why do you have to be in sysadmin-role to see who checked in changes?

                Ít would be nice, if you dont have to be in sysadmin-role to see wich user has made changes. thx.

                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  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                • SQL Doc - Rename or remove server name

                  When generating documentation in SQL Doc it would be nice to either rename or remove the server name. If I'm generating documentation for a client, for example, I would rather they not see the SQL Server name and get confused.

                  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 →
                  • Accomodate for people with colour blindness

                    One of my colleagues has colour blindness.

                    The distinction between a non-reviewed database (the grey circle) and a database with outstanding changes (blue / white icon) is difficult to see because of the fact that the icons are so small (the less pixels to compare, the harder it is by all accounts) and often can be far away (i.e. if there are other non-source controlled database between them on the database tree in SSMS).

                    It would be helpful to make a clear distinction between the icons - either make the grey icon a flat colour (i.e. remove the highlight within…

                    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 →
                    • Add button Stop/Start Checking for modifications

                      Sometime I work with proxy of my customer and my DB, linked to source control, can't connect.
                      Please, I need a Start-Stop button to stop the connection with the source control in this situation. Thank you.

                      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…)
                        5 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add contained database support in SQL 2012

                        Need to have better support for contained databases feature of SQL Server 2012. For example a new feature - user WITH PASSWORD is scripted as a user WITHOUT LOGIN.

                        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 →
                        • BUG(?): Rebuilding a table via migration script doesn't add the correct authorization commands

                          When rebuilding a table via migration scripts, the ALTER AUTHORIZATION TO... commands are omitted on the replacement table when the migration script is created by SSC.

                          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 →
                          • BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked

                            BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked

                            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 →
                            • The toggle button functionality

                              I have version 3.2.0.27. When you have conflicts, the toggle button at the top of commit and get latest won't uncheck items that SQL Source decides to check. I have to select all the items and then click a box to uncheck, then check the ones I want. If I don't want to resolve the conflict yet, it's not ideal.

                              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…)
                                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Provide a way to post configurations that must be implemented as TO DO items

                                I have a service broker application where some parts such as service routes etc must be defined per database configuration, thus certain components change per installation so it would be nice to tag such items as TO DO items, like wise once complete when comparing to latest or changes the item is not displayed as an object that has changed.

                                Going further it might be nice to populate table data that also configures per installation as well

                                perhaps use of extended properties, or a file present in source. I had taken the source code and placed a comment in it…

                                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…)
                                • Auto link source control to repository

                                  My use of Source Control is in its infancy, but it would appear that when you commit your changes to Source Control, an entry to your repository (for us its TFS) and the version number. From what I understand this is only used by the compare products. But why can't this link be used by Source Control to automatically link others to the same repository?

                                  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…)
                                    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SQL Source Control Configuring Data Compare Options

                                    Make it possible for us to configure how SQL Source Control does its data compare. There are some great settings that work within SQL Data Compare 10 that allow a user to configure how data in each table is compared between data sources. Currently the main feature I want is to allow the selection of table columns to actually compare (i.e. one column is an identity field which isn't always the same).

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

                                      Bug: the function object_schema_name is not recognized as a valid system function, and is wrapped in [] when committed to subversion backend. Scripts defining tables or stored procedures that use this function have to be edited to remove the [] before they can be successfully run. Please fix this, this is a function we put into almost every table as part of the default value in a "created by" field.

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

                                        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 →
                                        • Step 4 takes a very long time since I upgraded to 3.1.0.5208.

                                          Seems that since the release of SQL Source Control 3.1.0.5208 step 4 has been taking a very long time. I don't know if this is just my set up or is happening for everyone. Also, if I try to do a dedicated database development then step 4 never finishes.

                                          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…)
                                            11 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7 8 9 10 11 19 20
                                          • Don't see your idea?

                                          Feedback and Knowledge Base