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. Define sets of tables to make selecting tables easier

    When comparing big database there are often performance issues. For that reason I need to select only the tables that I need in the current comparison. This is a tedious thing to do.

    I propose the following feature: Let me define sets of tables. Then, in the table selection list, I want to be able to quickly enable or disable all tables in a given set. That way I could create a project with all tables off by default and a few table sets. I could then turn on only the specific table sets that I need right now.

    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 →
    • Allow include/exclude via copy/pasted ids

      I have 1200 rows, 800 of which I want to exclude. I'm putting the IDs I want to exclude up next to the the checkboxes in SQL Data Compare and manually comparing each ID to decide whether to click the checkbox.

      This is tedious, yes, but worse is when I scroll, sometimes the next time I press space bar to unselect the selected rows, it decides it's actually active on the table differences window rather than the row differences, and undoes ALL of my 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…)
        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
      • Export to excel with highliting the differences

        Export option to Excel with colour Formatting which data is changed

        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 →
        • Issues when check items on the detail with Space bar (instead of mouse click)

          On SQL Data compare, where we check Records CheckBox (on the details) with the space bar (instead of mouse click), it doesn't check the Tables Checkbox.

          This means that when I click synchronise, it informs me that I didn't check anything, which is not true.

          I've just download the latest version (11.1.3.23) and it still done the same issue.

          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 command line equivalent of GUI compare

            I would like to see the equivalent CLR commands for the compare that has just been run using the GUI.

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

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

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

                                          SQL Data Compare

                                          Feedback and Knowledge Base