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 http://www.red-gate.com/messageboard/viewforum.php?f=156

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

  1. On the fly comparison column filters

    I would like to be able to have filters (Both on values, and differences) on the comparison result columns available on the fly, so I can see highlighted values and column headers only for certain rows. (eg for specific or ranges of Values or ranges of percentage difference, or when one column has differences)

    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 option to show a third 'difference' column for numeric data

      Being able to sort by the difference (Preferably with an option of straight, absolute and percentage difference) would allow a quick indication of if there are major differences, and would show potential correlation between differences.

      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 →
      • Progress bar

        I suggest a little work on the progress bar accuracy. I have a database with a dozen or so tables containing 650 million+ rows per table. When I trigger the data compare, the first comparison step, the progress bar takes approx. 40 minutes to get to 100% but then will continue "comparing databases" for another 40 minutes or so.

        Also on the dialog showing the progress bar, it would be nice to have a start time, end time, and elapsed time displayed somewhere on the screen.

        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 →
        • "Exclude All" by default

          I'd like to have a Project Option to "Exclude All" by default, so i will mark only diferences i want to deploy.

          I know i can click "Actions" -> "Exclude All", but i have to do it a lot of times.

          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 →
          • Run as different user.

            After upgrading to v10.7.0.23 I am no longer able to run this application as administrator. This is unacceptable.

            FYI: I am still able to do this with SQL Compare v10.7.0.18.

            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 →
            • Show the progress of comparison and deployment in the Windows Taskbar

              When running on Windows 7 or later, show the progress in the popup window also in the Windows Taskbar. That way I can work with other applications and see when it is finished without switching between the other application and SQL Data Compare.

              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 →
              • Export Comparison Results to SQL table

                Though CSVs are useful in some contexts, they require processing. This is why having an HTML output like SQL Compare has been requested.

                However, it may be even more helpful to have an export option to create a new SQL database table with all the comparison results. This would streamline the process of querying and even custom reporting on the comparison results.

                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 →
                • where clause

                  Increase the max size for the where clause editor (roughly 4k chars currently).

                  I generally have to compare larger sets of data where I'm using the IN keyword on the primary key and specify a large set of keys. If needed, Data Compare should loop the where clause based on the max query length and then combine the results.

                  Currently for me to get this to work in data compare, I need to run a compare multiple times against smaller subsets of the same keys; OR, generate my own sql queries that compares the tables from DB1 to DB2 manually…

                  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 →
                  • Columns are truncated in CompareView => make columns resizeable

                    Some columns are truncated in the compare view, i. e. the owner column. Often information of the database is not shown which is essential for us and resizing is not possible.

                    Could you please improve the view and make the displayed columns resizable.

                    THX
                    Markus

                    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 →
                    • date = smalldatetime

                      The ability to equate a date field with a smalldatetime field that has "00:00:00" for the time. Ex: '2014-01-01' is equal to '2014-01-01 00:00:00' in most scenarios. These are considered different dates as of 10.4.8.62 of SQL Data Compare.

                      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 →
                      • Add option to clear tables completely before import

                        Sometimes I want to transfer data from one database to another and I don't want to retain the existing data. I would like an option that will truncate the tables so that I can then import the new data without worrying about violating referential integrity.

                        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 →
                        • Export Comparison Results tool doesn't work!

                          Export Comparison Results tool doesn't work in Ver. 10.4.8.62

                          The tool exports ALL results to a csv file even if one or more of the 4 check boxes are unchecked. The boxes are: 'Identical', 'Different', 'Only in <source>', Only in <target>'

                          Why can't something so simple be made to work?!

                          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 →
                          • Add try / catch with rollback option to the resulting deployment script

                            In the deployment script that data compare generates, it would be great if there would be an option to have the script wrapped in an Try / catch statement with a rollback statement in the end catch part. Also, having the option of ommiting the GO commands generated into the scripts would be great.

                            so the boilerplate for the try/catch block around the generated script could look something like this :

                            BEGIN TRY
                            BEGIN TRANSACTION
                            ...
                            SQL Code here
                            ...
                            PRINT 'ALL DONE'
                            COMMIT

                            END TRY
                            BEGIN CATCH
                            PRINT '** ROLLING BACK TRANSACTION **'
                            ROLLBACK
                            DECLARE @tErrorMessage NVARCHAR(MAX)
                            SET @tErrorMessage…

                            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 →
                            • Run SQL Queries and compare results

                              We have a scenario where table ‘abc’ in database1 is split to new tables ‘def‘ , ‘ghi’ and ‘jkl’ in database2. It is very complicated to map the tables, columns and choose a stable primary key to verify the new tables with the old table.
                              And so we need to be able to join the tables to generate the data to verify old and new tables.

                              It would be very nice to have a feature to run the query for database1 and query for database2 and compare the results.

                              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…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Have an application or project option that will allow you to turn off automatically checking differences

                                Have a SQL DATA Compare application or project option that will allow you to turn off automatically checking differences. In Sql Compare this seems to work a little better in that only a few or no items are automatically selected when comparison results are displayed. Right now, all differences are selected in SQL Data Compare.

                                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 →
                                • Export Comparison Results ignores "Rows to Include" settings

                                  Having carried out a comparison which returned a large number (4m+) of rows with differences but just 24 that were in one database but not the other, I tried to export the 24 rows to CSV.

                                  Unfortunately, having un-checked the "Different" and "Only in <DB1>" checkboxes in "Rows to Include", leaving just "Only in <DB2>" checked ("Identical" was greyed out as the comparison had excluded matches), the export then ignored these settings and exported the entire 4m+ rows.

                                  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 →
                                  • object mapping unmap certain fields for all tables

                                    in Object Mapping, it would be good to have a choice to unmap a field(s) for all tables. For example, nearly all my primary tables have a timestamp field [ts] . I never want to compare this field between tables in any database. (I have a TS field for faster indexing by ODBC apps)

                                    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 →
                                    • Add an option to data compare to record & display statistics.

                                      These could include total compare time, how long each individual table and/or view took, and perhaps even suggestions for indexes which might speed up the compare.

                                      This would help to identify bottlenecks and hopefully to eliminate some of them.

                                      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 →
                                      • only show columns with differences

                                        Automatically undisplay columns that show no differences what so ever (indicated by not highlighting the columname)
                                        when inspecting a comparison without recalculating the entire thing. I am bothered about a huge number of columns without interesting
                                        information, beacuse they don't contain differences at all.
                                        I only want to focus on the few columns containing the differences (i.e. indicated as colour highlight on the column name field).
                                        Manual deselection for over 100 columns is not practical.

                                        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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Ignore column when viewing row differences

                                          Sometimes when viewing row differences, you see a column with differences that appears to be unimportant. It would be nice that you can right-click on this column and have the possibility to ignore that column. In the current system, you have to go to 'Edit Project' -> tab Tables & views -> find the table -> alter 'Columns in Comparison' -> Click dropdown button to get a list of all columns of that table -> scroll to the column you want to leave out of the comparison -> deselect it -> recompare.

                                          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 →
                                          ← Previous 1 3 4
                                          • Don't see your idea?

                                          SQL Data Compare

                                          Feedback and Knowledge Base