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 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. Add the ability to select the tables for comparison using a SQL query

    Ability to select tables for comparison in a data compare project based on results from a query like “select tablename from… where ....?

    21 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 →
    • "Disable foreign keys" should also apply to views

      During deployment, the option “Disable foreign keys” should apply to views also, by ignoring the foreign keys on the table(s) that underlie the view.

      I am using specially-defined views, on 35 tables, to compare only rows for a single customer. With this many tables, there naturally will tend to be foreign key issues during deployment. When comparing views, SQL Data Compare does generate SET IDENTITY_INSERT statements on the underlying tables, but not the equally necessary ALTER TABLE…NOCHECK CONSTRAINT statements.

      Here are two sample CREATE VIEW statements:

      create view SDCmp.Client as
      select * from dbo.client where id = 9779

      create view…

      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 →
      • Create an option to analise an index without PK or unique index

        When we compare two tables without PK or unique index, we need to manually choose the index of the table that we want to be compared by the tool.
        However, with hundred of table we need to find all the table one by one in the result set and do this operation manually.
        I suggest to be created one button to facilitate the choice of another comparison key for all table at the same time. Something like choose the index that have more columns.
        It's going to be a lot of work do that for every one of the two…

        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 →
        • Create an option to order the comparison key

          When we compare two tables without PK or unique index, we need to manually choose the index of the table that we want to be compared by the tool.
          However, with hundred of table we need to find all the table one by one in the result set. If we have a option to order the collumn comparison key, all the table with this problem will be together and it's more easy to analise the problem.

          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 →
          • Allow SQL statements to be used as a SQL Data Compare source.

            Allow a well-formed SQL statement, including joins to other tables and allowable functions, to be used to data compare between environments. This would be similar to how the "WHERE clause" works today.

            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 →
            • Drill into Data Compare Report to get mapped columns.

              It is possible to get table mapping in Data Compare Report, but it will be useful to expord columns mapping to, I mean drill into Object in existing report to view mapped columns.

              Regards,
              Shimon

              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 →
              • Allow "where" clause filtering with backups

                Currently you can't use the "where" clause with backups e.g. you're comparing a backup with a live db and want to filter a transaction table by id.

                Ideally we should be able to filter using the where clause when using backups

                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 →
                • 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 →
                  • When selecting a table the preview process takes a long time or hangs

                    In this example I use data from a different table.
                    If I remove the Foreign Keys from the target table, the preview process is very quick and doesn't hang. To avoid this, I remove the Foreign Keys from the target table until I have created the data. (Knowing that the Foreign Keys in the source table prevent invalid data from being created. Additionally, I avoid generating data that will cause the Foreign Keys in the target table to fail.)
                    When the data generation is complete, I re-create the Foreign Keys in the target table.
                    I am not sure the cause…

                    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 →
                    • Relaxed data type matching for comparisons

                      I'm using SQL Data Compare extensively as part of a refactoring project. As we optimize data types we end up with situations where we cannot compare source and destination table data due to mismatching data types. I'd like to request a flag that implements implicit/explicit SQL Server data type conversions. For example, I want to be able to compare and synchronize DATATIME/SMALLDATETIME to DATE or VARCHAR to TINYINT/SMALLINT/INT.

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

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

                            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…)
                              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

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

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

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

                                          SQL Data Compare

                                          Feedback and Knowledge Base