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

    310 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…)
      15 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow me to specify a subset of columns for static data like I can in SQL Data Compare

      I do not want to source control certain columns in my reference tables (e.g., update date/times since these are different on each server and get set by a DEFAULT).

      253 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…)
        8 comments  ·  Static Data  ·  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

        235 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…)
          10 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
        • Support different static data per customer

          I have a single schema for all customers but different reference data for different customers. It would be nice if I could manage this all within SQL Source Control. This should also be understood by SQL Compare and my continuous integration system when it comes time to deploy this to my different environments and customers' sites.

          228 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…)
            6 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
          • Undo data changes

            I can undo any DDL operation but I don't have the option to undo a data change in a source controlled table. I think data changes should also be in the list of changes I can undo.

            181 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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
            • Add Filter for Static Data Selection

              Add a filter for static data, similar to the feature available in SQL Data Compare. This will facilitate source controlling data for tables that contain a mix of static system data and user content.

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

                98 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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                • Custom comparison key in SQL Source Control

                  When adding a static table to be managed by SSC the comparison key is automatically selected. Our tables have auto generated INT ID columns as PK used in FK's. In our Static Data tables we have other columns that are unique and for them we have UK’s that we would like to use as the comparison key.

                  Here is another with the same issue...
                  http://www.red-gate.com/messageboard/viewtopic.php?t=16498&highlight=comparison+key

                  I have not found any workaround for this yet at least.
                  I believe that this would be a great improvement for SSC and would be used by many. If you agree please vote for this…

                  69 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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                  • Changes to data in Static Data Linked Tables should be included in the Migration Script, just as changes to the schema are.

                    If a table is linked as static data, any changes to the data should automatically be included in the migration script, just as changes to the schema are. Having to write a manual script or use the separate compare tool is extra work, and small changes are easy to miss.

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

                      31 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  ·  Static Data  ·  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.

                        23 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 →
                        • Commit data and schema changes separetly

                          A table is under source control and the data of that table is linked as static data.
                          Both table definition and data has been changed and are visible in the 'Commit changes' tab.
                          Since the data is just edited and changed for development purpose it should not be committed.
                          But in this situation it is impossible to only commit de table definition.
                          When checking the table the data is also checked (and the other way around also).

                          It would be nice to be able to commit the changes separetly.

                          20 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 →
                          • Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace is simply not accep

                            Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace of the tool is not acceptable.

                            15 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 →
                            • Put blue indicators on Object Explorer for changes to static data

                              I have my database linked to source control, and if I make a change to a schema, it shows a blue dot in the Object Explorer to indicate there are pending changes. However the same does not apply to static data – if I change some data in a table that is setup for static data source control, there is no icon to indicate there are changes to be committed. The data change does appear when I go to the commit changes tab however.

                              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…)
                                1 comment  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                              • Incorrect differences shown for data changes

                                I just did a data edit (inserted one row) but in the differences I see three rows inserted and two removed. Two of the rows inserted are letter for letter identical to the two rows removed.

                                Doesn't really matter, just a little confusing to read

                                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…)
                                  2 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                • Must treat Static Data like source code

                                  Our application is highly metadata driven thus we must treat our static data like source code. Specifically we need accept deleteions that are made locally, apply insertions made globally, and identify the differences. Currently Sql Source Control does NOT differentiate between rows missing from the local database because either 1) the local developer deleted them or 2) they were added by a global developer to the latest source code controlled version. In case 1, we want to drive that deleteion back into the latest source code controlled version. In case 2, we want to drive that insertion into the local…

                                  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…)
                                    2 comments  ·  Static Data  ·  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

                                    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…)
                                      3 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                    • static data, Bulk insert for get latest

                                      Do not use transactions but use bulk insert in order to reduce the get latest time. A 'flush and refill' approach using bulk insert should be faster in hours with 10K plus records.

                                      A two processor, dual core computer with 8GB of RAM and a Windows experience index of 6.5 takes over 8 hours to get lates on 50K records.

                                      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 →
                                      • Need ability to replace specific Data Table columns with functions, and then ignore in comparisons

                                        One of the things that we have in all of tables is a "DateCreated" and "ModifiedBy". DateCreated is supposed to be the UTC time of the creation of the record. For Metadata supported by SQL Source Compare -- this is becoming the date the script was written, rather than the date the production goes live. We would like to state that the actual column should be replaced by GETDateUTC(), rather than the time the record was first created in development, and then we want to tell SQL Source Control to ignore the underlying column for comparison.

                                        We want to be…

                                        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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Link/Unlink Static Data - change to non-modal dialog

                                          I am trying to pick my tables for the static data feature I just dound and i'm using "explore data" to find the table I want to store the data for. The popup however is modal so I cant scroll the data explorer without saving the ones I just ticked.

                                          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  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base