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. Support different format of source control source files.

    By default during initial sync Red-Gate creates object’s files with binary attribute. It is more relevant to them to be string type -- Unicode (which they are actually). It is necessary due to some file-diff tools incorrectly handles binary files. There no way to change default file creation attribute (binary).
    Let user choose target sourse control object's file attribute.

    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 →
    • Ability to disable transactions when updating DB

      Ability to disable transactions when updating DB with latest changes.

      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 →
      • Foreign keys recreated with NOCHECK during data sync

        We have the same issue as noted here: http://www.red-gate.com/messageboard/viewtopic.php?t=13662&highlight=foriegn+foreign+key

        The FK is recreated with NOCHECK during data sync which triggers a schema change.

        62 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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
        • Switch tags on linked database database

          My test and acceptance environments are pretty much slaves I'd like to be able to 'switch' from tags/1.0.0.0/Database to src/2.0.0.0 with unlinking and relinkinging the database. In other words a switch action is basically a get latest from another branch.

          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…)
            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Object Explorer Details context menu

            When right-clicking a database in the Object Explorer Details page. The context menu doesn't reflect the database you click on. It still relates to the database selected in the Object Explorer tree.

            SSMS 10.0.4000
            SSC 2.2.1.23

            Thanks
            Phil

            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 →
            • User-configurable tab width in diff views

              When viewing differences prior to check-in (or prior to get-latest), the DIFF view always expands tab characters to 8 wide. Our standard is to use hard tabs to indent, 4 characters wide.

              It would be nice to be able to tell SQL Source Control that our tabs are 4 chars wide, so that the diff displays are easier to read and interpret quickly!

              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 →
              • SQL Source Control Static Views (or Table Subsets using WHERE clause)

                I would like the ability to source control a subset of a table (perhaps using a view).

                I have inherited a database where lookup data is intermixed with user defined data. We reference the lookup data in the table using a code (VARCHAR) that is unique when another field is NULL, so it is possible to ensure that records are created/updated/deleted without concern for the primary key involved.

                For more information, you can refer to this forum post:
                http://www.red-gate.com/messageboard/viewtopic.php?p=50087

                75 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 →
                • 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…)
                  • When using SourceGear Vault Process or allow rename of folders done in Vault Client

                    When using SourceGear Vault when we create a branch for different development fork we may need to rename the folder. At present there is not a way to edit the link to the folder. We have to unlink and relink the database. If the folder is not found it would be nice to have a way to browse to an existing folder.

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

                      Would be nice if SQL Source Control supported clearcase, or if an example of the config file usage were created.

                      13 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…)
                      • external diff viewer

                        When comparing differences a double-click on the object could open a external diff viewer (if configured)

                        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…)
                          5 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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 →
                          • Allow saving default filters

                            With 2.2 we now have the ability to create rule filters. However these are database specific. Need the ability to have a default set of rules, or copy rules from one database to another.

                            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 →
                            • On closing, ask to Commit changes

                              Working in a Team development, I do not want changes not to be commited to TFS. If I forget on closing, then a pop up window should ask you if you want to commit your changes.

                              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…)
                              • "Select object in Object Explorer" in Commit (like SQL Search)

                                "Select object in Object Explorer" in Commit (like SQL Search), makes it a lot easyer to continue working on things, that is not yet commitet.

                                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 →
                                • Make SQL Data Easier to Merge

                                  Currently, SQL Data files contain a bunch of insert statements, but the order of the insert statements can be inconsistent. For example, new records might get inserted on the top or the bottom. Also, multiple SET IDENTITY_INSERT statements sometimes get created. This makes it difficuly to merge data changes between multiple branches in TFS Source Control. If the Insert statements had a consistent order and only included one SET IDENTITY_INSERT diffs and merges would be easier.

                                  74 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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow me to specify what tables to sync instead of a Database

                                    In our environment multiple projects make ddl changes to same database. But they dont make changes to a same table/procedure. It would be nice to have advanced settings which let one specify what objects go to what folder instead of an entire database.

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

                                      In v2.2, which is expected to be released in the next few weeks, we’ve implemented Object Filtering, which allows you to specify which objects to inlcude/exclude for source control. Therefore, you could link a database and set up a filter so that only the tables/procedures your interested in for your project would be source controlled. Would this help?
                                      You can get the v2.2 Release Candidate at http://www.red-gate.com/messageboard/viewtopic.php?t=13668 to try this out.

                                    • I want to look at SSC and see a det summary of all linked server/database instances and version

                                      It would idea if you could see all linked server/databases within SQLSource Control and the version that they are running or at least the last version that they sync'd with

                                      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 →
                                      • Revert changes show in History

                                        I word like to hav the posibility to revert changes using a rightclick i history.
                                        Both all (opper pane) the changes in a commit, and the changes to a specific object (middle pane).

                                        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  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
                                        • source control version 2.2.1.16 takes forever to get latest , SQL 2008 R2, TFS

                                          source control version 2.2.1.16 takes forever to get latest , SQL 2008 R2, TFS

                                          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 →
                                          1 2 5 6 7 8 10 12 13 14 15 19 20
                                          • Don't see your idea?

                                          Feedback and Knowledge Base