SQL Data Compare

Welcome to the SQL Data Compare feature suggestion list. Find out more information about SQL Data Compare at http://www.red-gate.com/products/sql-development/sql-data-compare/

If you have any questions, need help or have found a bug in SQL Data Compare, please visit the forums at https://forums.red-gate.com/viewforum.php?f=201

How can we improve SQL Data Compare?

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.

  1. tracking/logging deployments

    It would be nice to have a way to automatically log all deployments from that are done from Data Compare.
    At our workplace we there are several individuals who sometimes do deployments of data from our staging-db to the live-db. It would be useful to have an overview somewhere where you can look up when the last deployment was, or who did the last deployment.

    Maybe through a link with Confluence or JIRA. Or maybe even directly in the target-database.
    For the latter it would suffice if a user could specify a query that would automatically be added to each…

    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 →
    • Bring back the print function so we create documents, not just excel exports.

      Bring back print function as in previous versions.

      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 →
      • Make the target (server+database) independent of the data set (tables and views)

        I'd like to store in a Data Compare project file a list of targets that I can select very easily. A target is server+database. It includes credentials as well. I don't want to re-enter them all the time.

        I don't want to make many project files for them.

        The same is true for a selection of tables and views. I compare very large database and I need different subsets of tables depending on the current task I'm working on.

        Again, why a separate project file for them? I don't want that.

        Given that I need to vary both target and…

        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 →
        • Automatically discover new databases (incl. snapshots)

          I should not need to click refresh. Please automatically discover new databases (incl. snapshots) in the database dropdown.

          I frequently use Data Compare to compare database snapshots. I make a snapshot, make a bulk change to the data and want to see how it turned out.

          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 →
          • Stop uppercasing server names

            For some reason all of the servers offered in the dropdown list of servers are uppercase. Both recent and found on the network. Why is that the case? I entered them lowercase because I like them that way. Please leave my server names alone! :)

            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 →
            • Don't call the columns target and source because it might just want to compare to data sets

              Don't call the columns target and source because it might just want to compare to data sets. Those names assume a direction which is confusing. I think this is a change made in version 12.

              Also, the arrow on the top is barely recognizable as such now.

              The new flat design is all the rage right now but it reduces usability because buttons are not visible as such. Removing colors from icons also is a major usability degradation.

              Please do not optimize for design. Optimize for productivity. You customers are highly skilled and highly paid workers. Don't waste our time…

              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 →
              • Warn when comparing a database against itself

                This sometimes happens to me when I copy the database settings "left to right" and forget to modify them.

                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 →
                • Source "Scripts Folder" contents to determine Tables compared with Data Compare

                  We use multiple RedGate products, including SQL Source Control. Some data we choose to "Statically Link", so that it is always consistent. Examples would be when we map tables to Enum values in our codebase for instance and the contents of dbo.__MigrationHistory produced by EntityFramework.

                  I would be great when using SQL Data Compare and using a scripts folder as the source database, to have the option to only compare tables that have records in the Script Folder's Data folder ie:

                  C:/MyDatabase/Data/Schema.TableName.sql ...

                  At the moment I haven't found a good workflow that isn't painfully tedious to ensure that my…

                  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 →
                  • retro theme to make it look like SQL Data Compare 11

                    Had to use version 11 today because of a show stopping bug (which I've reported), but 11 looks so much more user friendly and easier to use than 12. Can we possibly have a "retro" look and feel option for version 12?

                    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 →
                    • Enable Transaction Isolation Option like in SQL Compare

                      Enable Transaction Isolation Option like in SQL Compare. In SQL Compare you can set the transaction level to one of five options. This is needed in SQL Data Compare to eliminate blocking.

                      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 →
                      • Application freezes when selecting columns

                        The application "pauses" / freezes for several seconds after selecting columns to include. Very painful when making changes to a dozen or so tables.

                        Love the tool, but please solve this!

                        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 →
                        • Summary with counts of column differences

                          When a data compare completes, if a table has differences, I'd like to be able to view a summary showing the columns that differ and how may rows differ for each column.

                          I just did this by hand today, selecting one column at a time on a 6 million row, wide table. Took an hour. With a summary page it should take just one pass.

                          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 →
                          • Move the "always include new tables" to the first page of the wizard

                            I think this would make the feature a lot more useful: the reason for this is that when you go into tables and views it compares FIRST, so if you wanted to change that setting then either you now have a bunch of tables to go and include that you wanted to add, or you now have to go find a bunch of tables that you didn't want to include and take them out.

                            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 →
                            • Only show tables from mapped owners (schemas)

                              In SQL data compare, If I have two schemas (dbo and test) in some database, and only map the test schema between the databases to be compared, when it comes to table selection, it shows all the tables in the dbo schema as unmapped. That is true, but I'd rather not have to see them. Suggestion: Hide the tables in unmapped schemas.

                              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 →
                              • WHERE clauses should accept (or not) WHERE consistently

                                The WHERE clause for a table can contain WHERE, and this works fine for comparison, but when you generate a deployment script it errors because the update statement says

                                UPDATE table SET value = 1 WHERE keyfield = 1 AND ( WHERE keyfield = 1 )

                                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 →
                                • Option to cursor through grids by row, rather than change

                                  Often I need to mark a set of changes where the changes are not all in the same (or visible) columns. As a result, using the down arrow to go to the next record skips a lot of records that I need to mark.

                                  This "smart" feature doesn't seem to be very useful when I'm working like this - can we have an option to turn it off, so that the cursor keys work just as they would in Excel, without trying to take me to the next change?

                                  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 →
                                  • Generated script data files should have a consistent record order

                                    When I deploy my changes to my script files the order of the records is slightly different and therefore shows incorrect differences when comparing the files using a comparison tool (Beyond Compare 4).
                                    The two attached files show as having two differences. The only actual change is for the record with the id '8e0202a2-aab5-4b68-91d9-3575498dff66'.
                                    The change for the other record is only showing because the order of the data is different.
                                    This happens consistently and can become quite confusing and annoying when this happens for multiple tables or where there are a large number of changes for a table.
                                    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 →
                                    • show difference for long columns

                                      For columns having differences yet where the start of the difference is longer than the viewing area:

                                      I'd like to see the start of the difference with some context. So, say you have 100 characters to work with in the display. Show 20 characters before the difference, then the next 80 characters, whatever they are
                                      The old 80/20 rule. Given 100% of space, show 20% before the diff then use the remaining 80% for whatever is left. Show as much of the difference as you can. So, if you have 100 characters to work with and the column is 200…

                                      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 →
                                      • Set default open mode: Existing Project or New Project

                                        Unless I'm missing it, there doesn't seem to be a way to select a default open mode in Data Compare (or SQL Compare) version 12. It always opens to a new Compare Project. Most of the time I'm working with saved projects so it takes extra steps to do what I want. Older versions of Data/SQL compare used to let you pick how you want to start the application.

                                        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 →
                                        • Highlight columns that have changed

                                          In SQL Data Compare 11 you could see what values had changed as they were highlighted in the row compare view. Now they are all one colour. Can this be brought back?

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

                                          SQL Data Compare

                                          Feedback and Knowledge Base