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. Select tables by size and row count

    In the list of tables and views where the user can choose the tables to compare it would be useful to be able to...

    * Exclude tables based on on-disk size
    * Exclude tables based on row count
    * Include tables based on these criteria

    Big tables can take a long time to compare. I regularly need to exclude many of them manually.

    I want SQL Data Compare to show me the table sizes and row counts for each table. I also then need a quick way to say "check/uncheck all tables with less/more than X megabytes in size".

    This…

    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 →
    • We need a capability to have a custom key that derives from other table(s) other than the compared tables.

      Comapre table A with table B.
      table A table B table C
      ln_nbr prop_nbr prop_nbr
      ... ... ln_nbr
      ...
      ability to join table B and C to get the ln_nbr.

      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 →
      • Add support for an "/Assertidentical" switch similar to that of SQL Compare.

        At the moment, there is no way of testing to see if any changes exist when running SQL Data Compare from the command line. In SQL Compare, it returns "safely" an error code 79 which can be used to determine if any deltas exist.

        In SQL Data Compare, the only work around is to wait for the sqldatacompare action to fail and to check for error code 63 to know if no changes exist. This failure could bubble up if a calling program exists, thereby causing undesired effects as a result of the error being thrown.

        Thanks.

        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  ·  Flag idea as inappropriate…  ·  Admin →
        • Create an option where you can exclude tables or views for recompare where rows are identical.

          If you have a lot of tables and you compare all of them. Then, you'd like to deselect those that return identical rows from any refresh or recompare. Its tedious to go back and deselect 200 tables from Tables & View so they don't get recompared.

          Could be an option on the deployment wizard as well.

          [x] Recompare after deployment
          [x] Exclude tables & views with identical rows

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

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

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

                                          SQL Data Compare

                                          Feedback and Knowledge Base