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

75 results found

  1. Fix the link on the this page (How can we improve SQL Data Compare) that suggests to visit the forums (says forums doesn't exist)

    Fix the link on the this page (How can we improve SQL Data Compare) that suggests to visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=145 (says forums doesn't exist)

    1 vote
    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 →
    completed  ·  Paul Stephenson responded

    Thanks for your report. I’ve updated the link to the correct SQL Data Compare forum URL.

  2. split huge sql script to multiple serialized with selected size

    Now there is no option to split the script generated for sql data compare for very large data. It will make memory issues while running huge data script. Splitting the insert script for migrating data will be a good solution.

    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

  3. Enable Transaction Isolation Option like in SQL Compare

    Enable Transaction Isolation Option like in SQL Compare. In SQL Compare you can set the transaction level to one of five options. This is needed in SQL Data Compare to eliminate blocking.

    7 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. compare two tables in the same database

    I don't see why the tables have to reside in different databases, backup, source control, or scripts folder in order to run SQL Data Compare.

    It wouldn't be much fuzz to add the ability to compare two tables regardless (i.e. in the same database). Sometimes I just need to divide the common traits from the differences, in order to plan some work.

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

  5. Ignore Calculated fields

    When a database has calculated fields, SQL Data Compare seems to process them and it takes a long time. Since these fields are calculated, they will never be updated so these should be ignored. At this time, we have to un-select each calculated field to improve on performance.

    9 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

  6. window resize handles missing

    On Windows 7, the edges of the SQL Data Compare window don't seem to allow window resizing, and there's no visible border separating the window from the background.

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

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

  8. Add the ability to ignore specific column types, specifically datetime types.

    My primary usage as QA is to use some DB as a baseline, run old code against it, run new code against it, and compare the results. Most of the differences are the times that records were updated or other time related fields. I am only interested in the data differences. All of the datetime field differences clutter the comparison and increase my analysis time by about a factor of 20.
    I know I could go in and manually find all of the datetime fields in each of the 300-600 tables (depending on the DB) and un-check all the datetime…

    17 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

  9. JSON

    The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"

    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

  10. JSON

    The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"

    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

  11. compare one source table to 2 or more destination tables

    Allow data from one source table to be mapped to 2 or more destination tables. Due to requirement changes we needed to split data from one table in to two separate tables but data compare will only map one source table to one destination table. Some data has to be duplicated on both tables and some belongs to one or other of the new tables.

    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

  12. Provide option to edit deployment script before running it

    Sometimes when copying data from server to server I need to change soemthing in the deployment script (e.g. replace a guid with another guid for a FK to work). Please allow editing the script before running it through Data Compare (currently I have to copy it, edit it and run it manually)

    4 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

  13. Add ability to migrate CDC tables from one database to another

    When we upgrade an application, say by adding tables, we use frequently use SQL Data Compare to move the data from the old database to the new, upgraded database. It would be great to be able to migrate the CDC data for the tables in the original version of the database to the new version!

    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

  14. Custom computed comparison key for matching table records

    Originally introduced in this thread: https://forum.red-gate.com/discussion/comment/149220#Comment_149220

    This is a common problem for us when using Data Compare. Parent table has unique constraint on a char field alongside an identity field which also serves as a one-to-many foreign key in the child table. The child table uses an identity field to distinguish each row but there's no guarantee the id's will be the same across databases so only the parent can be matched but the child table only has the parent_id identity fk which is not a viable comparison key.

    My proposed solution would be to allow user to define…

    15 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

  15. Provide explicit table and schema exclusion

    This improvement is similar to https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/4157645-exclude-special-schema-from-datacompare, but I would like to sketch the idea out a little further.

    SQL Data Compare should provide a filtering option that allows the user to exclude entire schemas from comparison, or to exclude tables explicitly. This can be done somewhat at the schema level by unmapping an Owner.

    But this doesn't provide the feedback on the main screen that I would like to see. There should be an additional Type on the main screen named "Deselected for comparison". Tables or schemas that are not mapped shouldn't be put into…

    7 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

  16. Be more robust in the face of Transport Errors

    Data Compare almost always fails because of frequent (but short) network outages. If we could specify the timeout, this problem would be solved.

    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

  17. The "Help > (?) Content" menu item in SQL Data Compare 12 links to the SDC11 docs: http://documentation.red-gate.com/display/SDC12/SQL+Data+

    Just an FYI

    1 vote
    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 →

  18. option to exclude tsqlt tables and schemas

    SQL Compare can exclude tSQLt-related objects. SQL Data Compare should have a similar facility, at least for parity with SQL Compare and also to reduce false positives in the result

    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

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

    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

  20. Variables in Where Filters

    Using SQL Data Compare I sometimes save projects with dozens of tables mapped out, and where clause filters. Using a multi-tenant database, I often find I need to limit the results to those that have a specific CompanyId or something similar, and I want to be able to run the project for different values quickly. It would be very helpful if I could define a variable in the project ...

    e.g. @myCompanyId uniqueidentifier = '00000000-0000-0000-0000-000000000000';

    then use that in my where clauses so I only have to update it in one place when it is used in dozens of…

    6 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
1 3
  • Don't see your idea?