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 161 ideas
    • MySQL tools 21 ideas
    • Oracle 130 ideas
    • Redgate 0 ideas
    • SQL Change Automation 53 ideas
    • SQL Compare 173 ideas
    • SQL Data Compare 67 ideas
    • SQL Prompt 342 ideas
    • SQL Search 87 ideas
    • SQL Source Control 586 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. 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 →

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

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

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

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

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

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

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

  9. Where clause gone when multiple tables selected

    Earlier versions would maintain the Where Clause when it was the same for multiple selected tables. We have a project that never changes other than one part of the where clause but I have to re-enter the same where clause every time. It's only saved per individual row.

    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 →

  10. 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
    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. provide an option to halt the compare after 'n' mismatches to allow quicker results when expecting a perfect match

    when expecting a perfect match, please provide an option to halt the compare after a user-provided number of mismatches.

    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 →

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

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

  13. Escape to close value details

    In SQL Data Compare, when I click on the box to show Value details, the box pops up just fine. However, I really really want it to close when I hit Escape. Having to actually 'X' out of that box bothers me. I may have dozens or hundreds of records I need to check quickly, and it takes so much longer.

    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 →

  14. My notebook was stolen and I can't deactivate my existing licence

    My notebook was stolen and I can't deactivate my existing licence. Please help!

    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. Speed It Up on LARGE Databases

    I created a new project. DB has 2004 tables. I only care about ONE db schema - "pricemanager", so, about 20 tables, of which I care to compare just 11. It takes nearly five full minutes just to get a tables and views page I can choose from.

    WHY, can I not simply "FILTER BEFORE RETRIEVAL"? I know what I want, and it isn't 2000+ tables and 5000+indexes, et al.

    I JUST upgraded to 13.4.5.6953 in hopes of some speed improvement
    - all hopes were dashed when it ground on for the usual 5 mins.

    need to eliminate the 4 typical "who" columns for each of my 11 tables bearing these columns. This is, arguably, one of the WORST experiences a Product has to offer... It is SO slow!

    It is plain ridiculous to have to wait another five to ten minutes (NO EXAGGERATION) for every table I need to simply omit columns from... And while here, it is also RIDICULOUS that to edit my project to include another table, I have to wait ANOTHER FIVE MINUTES for "it" to go back to the DBs I already went to, just to collect the SAME objects, in the SAME state... GIVE US A "DO NOT RE-READ SCHEMA" OPTION! (Both while we have a project open and need to edit, OR when we first open SQDC - allow us to say, "JUST GET MY PROJECT'S CHECKED TABLES OBJECT DEFINITIONS" (getting 11 instead of 2004, now that's a speed-up waiting to happen...)

    I cannot attest to this Product being a "productivity enhancer" - simply because I waste tens of minutes while unnecessary schema reads are repeatedly done, and "it" goes off into la-la land simply when I exclude 4 columns from the a table compare! Shocking it should be this bad at Version 13!

    And, when I have the GRID of results on show, GIVE ME A RIGHT-CLICK TO EXCLUDE A COLUMN, there and then, while the grid is on view - and "REFRESH JUST THIS TABLE" taking into account newly excluded columns... SO. MUCH. FASTER. (Mark this "un-map" in the Project, too, PLEASE)

    And this is on a MacBook Pro, with i7 processor and 16GB RAM, and SSD, so it's no slouch - and the servers are via wired 10GB Ethernet, about 150ft away, so no network latency.

    ANY pointers RG can give to make this a usable tool would be greatly appreciated!

    I created a new project. DB has 2004 tables. I only care about ONE db schema - "pricemanager", so, about 20 tables, of which I care to compare just 11. It takes nearly five full minutes just to get a tables and views page I can choose from.

    WHY, can I not simply "FILTER BEFORE RETRIEVAL"? I know what I want, and it isn't 2000+ tables and 5000+indexes, et al.

    I JUST upgraded to 13.4.5.6953 in hopes of some speed improvement
    - all hopes were dashed when it ground on for the usual 5 mins.

    need to eliminate the 4…

    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…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  16. provide additional binary data view options (i.e. PDF, Word, HTML)

    When i am comparing tables with binary data i am limited to Ansi or Unicode Text, Hexidecimal or Picture. We are storing PDF, Word and HTML documents and i would like to be able to view those better to see the differences. If this is not possible how about an export to open the data into the actual application (like an "open with....." option)

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

  17. Azure MFA support

    Support Azure AD auth using MFA

    81 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…)
    4 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  18. Please don't cover the header with update notices

    When updates are available, you cover part of the header. Please do not cover this information. (screen shot available upon request)

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

  19. Add the possibility to trim leading white space

    An option for trailing white space does already exist. Unfortunately there is no option for leading white space yet. This would be very useful and propably is no big deal to implement.

    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. Maintain table mappings when switching comparison types

    If you have a project with a bunch of table and view mappings configured, you can easily switch between (similar) databases and retain those mappings. However, if you switch from the database type to the scripts type, even if the schema is basically identical, any mappings with filters get unchecked, but the rest remain selected. RedGate silently makes this change, and it should be considered a bug. Let me choose which action to take. If you try to re-enable those mappings, the filters are only applied to one side of the comparison, which is also an issue.

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