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.

110 results found

  1. Use the same"Where Clauses"

    Ability to use the same "where clauses" that has been set up for one server and when we change the data source to another server with same dbase schema it has to use the same where clauses that I've already been set up.

    13 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

  2. Make the target (server+database) independent of the data set (tables and views)

    I'd like to store in a Data Compare project file a list of targets that I can select very easily. A target is server+database. It includes credentials as well. I don't want to re-enter them all the time.

    I don't want to make many project files for them.

    The same is true for a selection of tables and views. I compare very large database and I need different subsets of tables depending on the current task I'm working on.

    Again, why a separate project file for them? I don't want that.

    Given that I need to vary both target and…

    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

  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. Option to untick all columns when excluding\including columns

    There needs to be an option to untick all columns as running a comparison of a couple of columns over a table containing 80+ columns involves laboriously unticking 70+ columns.

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

  5. Excluding columns from data comprison with options to include them in the deployment script

    Excluding columns from data comprison with options to include them in the deployment script because we need these columns as placeholders

    54 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…)
    3 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. Update all products at once rather than just SQLDC

    Have the "check for updates" check for updates to all installed RedGate products? This would be helpful for those of us on frequent updates - having to close SSMS to update Sql Source Control and then again to update Sql Prompt a few minutes later generally is a bit slow...

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

  7. Preview XML Datatype

    Can you plead add feature to view/compare XML datatype. Current Viewer is not good enough to compare XML data

    10 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

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

  9. Disable unique constraint indexes

    If a table has a unique constraint index on say the name column and the change is just sapping the names on the IDs. The script to update the names ends up failing because it causes a unique constraint violation, but if the index is disable, then the update runs, then the index is rebuilt the unique constraint does not cause a failure.

    12 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

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

    21 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

  11. 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 the "could not be…

    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

  12. Provide an automatic custom key option on Tables & Views tab

    It's extremely time consuming to have to go to each individual table to create a custom key for comparing tables. Even with the common option of holding Shift to select a range. I have databases with hundreds of tables, and not all have a PKey. It would be nice to have an option that automatically selects all columns on the Tables & Views tab. You could even offer other options to select certain columns, or other ad-hoc options, for what columns to use in the compare process.

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

    19 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

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

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

    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…)
    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. Exclude special schema from datacompare

    I would be nice if you could set a filter in the project file which indicates which schemas to ignore.
    So tables in this schema will never shown in the database project.

    18 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

  17. SQL Data Compare needs the cool functionality of exporting reports as HTML currently found in SQL Compare!

    The below description moved from https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/3137395--report-switch-similar-to-that-of-sql-compare:

    I would like to see SQL Data Compare get the /report switch like SQL Compare does. With SQL Compare I usually generate an interactive report to store along the generated script in our build process. This allows to review changes packaged into a given build. Having the same kind of reporting capability from SQL Data Compare would allow us to get the full picture of a given build's database changes (for static data, precisely).

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

  18. Compare Sys tables - I want to compare SQL Jobs

    Please add an option to make the Sys tables available for comparison. I want to compare SQL Agent Job definitions in the MSDB database. At this time, SQL Data Compare and SQL Compare cannot do this. Everytime I have to promote jobs to a new environment, I have to do a manual comparison of the SQL Job defintion. Very tedious.

    51 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…)
    7 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. Filters for the "Tables & Views" tab

    Filters for the "Tables & Views" tab

    When working with databases that contain thousands of table, it takes so long to generate the list of tables and views that data compare is practically useless. It would be great if when you click the "Tables and Views" tab, it would not automatically try to retrieve the entire schema list, but rather give you the option to specify a filter for schema and/or object name and then click a button to build the list on demand. So when you only nee to sync one, or a few tables, it could retrieve the…

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

  20. Show how many records have been processed in a table (useful for large tables)

    It would be real nice to have a counter displayed on the "SQL Data Compare - Running" screen that shows which record number is being processed for a given table, for example "Processing record X of Y total records". This would be useful for large tables that have lots of binary data (images, files, etc.). This would help us determine whether or not SQL Data Compare is stuck in a loop. Right now the tool does show which table is being compared, which is useful, however, we have one table that has 25 GB of data in it (mostly PDF…

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