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

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

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

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

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

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

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

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

                          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…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create a Read-Only Executable version of SQL Data compare for Customers

                            I would like to create a SQL Data Compare project based on my requirements/comparisons/tables of my choosing, and be able to send my customers a read-only version of the project, where the only thing they can specify is which database's they would like to use.

                            The tables/data/schema that need to be synchronized would only be known at runtime, so the 'read-only executable' would have to analyze and then synchronize based on the databases of their choosing.

                            This would be an extremely handy tool to have since our customers databases are FDA regulated and so we would need to validate that…

                            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…)
                              4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • set precision for floating point comparison

                              [From a customer]
                              When comparing tables (particularly across 32bit and 64bit machines) floating point numbers specified to say 5 decimal places can differ in their representation in the lower order bits. It would be great to be able to get SQL Data Compare to round the numbers before comparing.

                              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…)
                                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Refactoring support

                                I'm currently going through a refactoring exercise and utilize SQL Data Compare extensively. However, I am getting too many (in my mind) false positives due to the refactoring.

                                I'd therefore like to suggest the following new features:
                                1) Ability to ignore leading spaces (just as we can ignore trailing spaces)
                                2) Ability to better utilize (implicit) data type conversions when utilizing DATE and DATETIME/SMALLDATETIME data types. For example, if a value has no time component that the DATE, DATETIME and SMALLDATETIME data-typed values shodul eb considered identical
                                3) Ability to compare disparate data types based on the build-in SQL implicit…

                                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 →
                                • Allow the Source Database to Control the Compare Set

                                  We do data conversions in separate rollouts. An example is a state-wide conversion by County. We are going to convert 5 counties every two weeks. The first set of counties ('A') have been converted, and it is now two weeks down the road.
                                  We create a backup of 'A', and convert the next set of counties ('B') into the database. Now the database ('AB') has 'A' and 'B'.

                                  One of our tasks is to insure that converting 'B' did not affect any data in 'A'.

                                  If SQL Data Compare allowed us to restore 'A' to another database, (call it 'A1')…

                                  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 tab to the SQL Differences section to show "All Different" rows

                                    There is a tab to show rows only in source db, a tab to show rows only in target db, a tab to show all rows exist in both but are different as well all rows exist in both that are identical.

                                    I really need a tab to show all rows that are different which would combine all rows only in source, all rows in target and all rows that exist but are different.

                                    The tab would basically be the opposite of "identical".

                                    There is an project option to not show "identical" rows but that requires a re-compare which can…

                                    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 →
                                    • Add "use <<Database>>" as an option in SQL Data Compare

                                      This option exists in SQL Compare but not SQL Data Compare

                                      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 →
                                      • Limit the usage of CPU

                                        I use Red Gate Data Compare for doing backup of our SQL Azure database. Very nice. I do this every morning via a virtual server on Windows Azure.

                                        It is not scripted yet because every morning I also get an alert from Windows Azure that the virtual machine's CPU is at 100%, which is blocking other processes.

                                        The reason is that Red Gate Data Compare consume all the CPU and triggers the alarm.

                                        I think Red Gate should implement a feature where you can limit the amount of CPU application can get.

                                        It's okay if the process take a few…

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

                                          Allow SQL Data Compare to correct copy DateTimeOffset fields. Please see bug SDC-1593.

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

                                          SQL Data Compare

                                          Feedback and Knowledge Base