Redgate

New and returning users may sign in

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
  • Sign in
  • Sign up

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.

Feedback

25 25 votes

SQL Data Compare

Categories

  • CATEGORIES
  • All ideas
  • My feedback

JUMP TO ANOTHER FORUM

(thinking…)

  • Searching…

    No results.

    Clear search results
    • DLM Dashboard 164 ideas
    • MySQL tools 21 ideas
    • Oracle 125 ideas
    • Redgate 0 ideas
    • SQL Change Automation 58 ideas
    • SQL Compare 196 ideas
    • SQL Data Compare 77 ideas
    • SQL Prompt 416 ideas
    • SQL Search 103 ideas
    • SQL Source Control 600 ideas

  • Redgate

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.

votes
Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Cancel Submitting...
  • or
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

  1. Do not include quotes in header row when exporting

    Please do not include quotes in the field names of the header row when exporting results to CSV. If you double-click on the resulting CSV, Excel cannot parse the column names. Instead, what you get is a single cell for each row with all of the quotes and commas in it.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  2. Add new tab to show "All Different" which would combine "Only in left", "In both but different" and "Only in right"

    I would like to see all the differences from "Only in left" and "Only in right" and "In both but different" in one view/tab.

    I know you can turn off "Show identical values in results" from the project options and then use "All Rows" but that requires a re-compare which can take a long time.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  3. SQL Data Compare does not play well with source control repositories such as SVN because of strange sorting behavior

    SQL Data Compare resorts the files during every check in preventing source control from correctly reporting changes.

    1) It prevents us from performing code reviews on data checked in.
    2) It prevents us from figuring out who made a change and when without huge efforts.

    We have tried to live with this behavior but are finding it extremely frustrating.

    When users add a new record, SQL Data Compare first sorts the existing file and then adds the new record to the top of the file. This makes it look like the user is performing multiple actions in source control causing the problems mentioned above. Instead, SQL Data Compare should sort the file AFTER the new record is added, or not at all.

    SQL Data Compare resorts the files during every check in preventing source control from correctly reporting changes.

    1) It prevents us from performing code reviews on data checked in.
    2) It prevents us from figuring out who made a change and when without huge efforts.

    We have tried to live with this behavior but are finding it extremely frustrating.

    When users add a new record, SQL Data Compare first sorts the existing file and then adds the new record to the top of the file. This makes it look like the user is performing multiple actions in source control causing…

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  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 the boxes ticked).

    Context:
    I use data compare a lot to analyse the impact of changes to code while developing - it provides a convenient way to do row-by-row comparisons without having to write the queries to identify the differences myself. However, where the product falls down in my opinion is the ability to export these results to a file where they can be used for further analysis. I have tried the CSV export and found it to be less hassle to write queries myself, to get something I can easily use.

    I am happy to discuss this with a member of the RedGate team. Thank you.

    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…

    10 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  5. An HTML Report Would be GREAT for QA & Regression Testing

    An HTML report similar to the one provided with the SQL Schema Compare utility would be an excellent tool for doing QA Testing and Regression Testing. The QA Analyst could send the HTML report link to programmers to fix erroneous data. (The databases being compared would be the Pre-Test versus the Post-Test data.)

    6 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  6. Allow sorting column by differences first

    It would be useful to sort a column so that differences appear first (or last). This could be done through a right click on the column headers and selecting the type of sort to perform.

    When comparing dataset with a large number of different rows (in my case 150k) where one column may having only 1 row that's different its next to impossible to find that row. Using the mouse to drag the scroller skips too much to be useful and paging down takes FOREVER.

    4 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  7. Read from SQL Native Compressed Backups

    Compare does not read from SQL backups that have used the native compression, although they can read from Redgate Backup files that have been compressed. I think that it should also be able to read from SQL compressed backups, as not all users will have Redgate Backup software.
    This would be beneficial to all, because it would create a way of restoring lost data without using a partial restore, to any user that has this Compare software.

    16 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  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 fields for each project, but that is also extremely time consuming.

    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…

    14 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  9. Connection Coloring

    Would like to be able to assign a color to server/database combinations so that I can easily see what database will be updated. For example, my PROD database would always be colored red and it would help from pushing changes to the wrong database.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  10. Allow ordering for Delete, Update, Insert statements to be in different order

    Often times updating a column on a table is dependent on a new record being inserted. I would prefer to be able to define the order for these to run in.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

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

    5 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  12. Setting Comparison Key and check box selection feature

    using the SQL Data Compare version 10 and Version 14.1 ( by the way I saw the same issue in version 13.)
    For tables where the user has to set the Comparison Keys
    In version 10 when the Comparison Key is SET and it changes to Custom , the check both between the two databases been compared is selected automatically. This is not the case in version 14.1

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  13. Add possibility to add CHANGE_TRACKING_CONTEXT to deployment script

    Provide an option (in gui and command line) to add a CHANGETRACKINGCONTEXT to the generated deployment script.

    This is helpful when using sql change tracking for synchronization to manage whether the changed made under a provided CHANGETRACKINGCONTEXT need to be synchronized or not.

    When enabling change tracking we have to make sure that the data in the tables are identical on both sides. Thats were we use SQL Data Compare, but the changes made for that "initial sync" shouldn't be recognized by change tracking for later synchronization.

    This would be very easy if you could just add an option to generate that context to the statements in the deployment script like this:

    DECLARE @contextString NVARCHAR(100) = 'SomeStringAsInput';
    DECLARE @context VARBINARY(128);
    SET @context = CAST(@contextString AS VARBINARY(128));
    WITH CHANGETRACKINGCONTEXT (@context)
    INSERT INTO dbo.Table (TableName, Text)
    VALUES
    (
    'TableName'
    'Test'
    )

    Provide an option (in gui and command line) to add a CHANGETRACKINGCONTEXT to the generated deployment script.

    This is helpful when using sql change tracking for synchronization to manage whether the changed made under a provided CHANGETRACKINGCONTEXT need to be synchronized or not.

    When enabling change tracking we have to make sure that the data in the tables are identical on both sides. Thats were we use SQL Data Compare, but the changes made for that "initial sync" shouldn't be recognized by change tracking for later synchronization.

    This would be very easy if you could just…

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  14. deployment script for single change

    Provide an right -click option to generate the deployment change for a row (or possibly multiple rows) from the difference panel. Similar to the Show Object Deployment Script option in the summary panel.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  15. 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
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  16. Ability to send bugreport from unlicensed trial

    I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  17. Ability to send bugreport from unlicensed trial

    I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...

    0 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  18. respect "smooth screen fonts" setting

    I have eyesight issues that mean that I need to take steps to reduce my eye strain when using the computer. One of the things that seems to help (counter intuitively, it would seem) is to switch off "smooth edges of screen fonts". However RedGate tools seem to ignore this setting altogether.

    Can you guys address this please? It doesn't affect SQL Source Control (fortunately), but render SQL Compare and SQL Data Compare physically painful to use at times.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  19. validate where clauses

    I have written were clauses for about 100 tables for data sync. while I do not want to sync just yet I do want to make sure I have no typos in the where clauses. Please add some option to run a "select top 1 where ..." from each table marked for comparison so I can fast check for where clause errors (currently I have to wait for each table to completely compare and if I have typos in the where clause of table 98 it will take me long time to find this out)

    4 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  20. Ability to Deploy Changes to Individual Columns

    After reviewing the result of table(s) comparison, it should be easier to choose by clicking a box by the column header for which column(s) you want to sync across to the target DB.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
← Previous 1 2 3 4 Next →
  • Don't see your idea?
Redgate
Redgate Terms of Service Powered By UserVoice

Your password has been reset

We have made changes to increase our security and have reset your password.

We've just sent you an email to . Click the link to create a password, then come back here and sign in.