Skip to content

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 https://forums.red-gate.com/viewforum.php?f=201 or our support portal.

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

  • or

5 results found

  1. Provide support for custom comparison queries

    While browsing the improvements, I notice a whole set of ideas centered around the ability to filter data, providing support for data types that may have changed between stages in the database lifecycle (development to QA to production for instance), and the ability to filter columns, changing column names, etc.

    All of this could be supported by providing custom SQL query support in SQL Data Compare.

    The tool should provide for a custom comparison query for the source and destination table.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

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

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Don't Compare VARCHAR columns as NVARCHAR

    Don't Compare VARCHAR columns as NVARCHAR
    I have a Table
    with 3 columns, 2 ints and a VARCHAR(10)
    CompanyID INT NOT NULL
    CustomerID INT NOT NULL
    YearMonth VARCHAR(10) NOT NULL -- Stores '2024-12' yes I know it should be CHAR(7)

    I populate the table, and take a Snapshot of the database.
    I then populate the table with new code
    I use SQL Data Compare to validate the data and see if I get different results. I am expecting the same, but could also expect differences.
    Table has apx 5 billion rows.

    Problem, I see The Active expensive queries generated are …

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Add support to export comparison results to MS Excel

    Can we please get the ability to export the contents of the SQL Data Compare results window (containing the rows with differences) to Excel, complete with the cell formatting seen in the application? I.e. headers for fields with differences in bold, cells with differences highlighted a different colour, etc.

    This functionality exists in SQL Prompt (exporting from SSMS, admittedly without the formatting) so surely should be possible from Data Compare also?

    Even better would be to be able to do this for all tables/subsets selected in the list of tables above the results window (i.e. all the data included by…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. BUG: RedGate Data Compare "Calculating time remaining" is inefficient and incorrect

    RedGate Data Compare "Calculating time remaining" is inefficient and incorrect
    1. It ignores filters set on the tables. So baseline counts are incorrect.
    2. Since it ignores filters set on the tables, it takes much longer, especially on large partitioned tables.
    3. It runs the count queries sequentially on each data source, even though they could run in parallel.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
  • Don't see your idea?