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

104 results found

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  3. 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)
    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)
  4. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  5. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  6. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  9. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  10. 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)
    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)
  11. when expecting a perfect match, please provide an option to halt the compare after a user-provided number of mismatches.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  12. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. My notebook was stolen and I can't deactivate my existing licence. Please help!

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  14. 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…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  15. 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)

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. When updates are available, you cover part of the header. Please do not cover this information. (screen shot available upon request)

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. 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.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. When creating deployment script, would like the option to select from the list of dependencies rather than all or nothing.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  20. I need to compare and sync history of temporal tables as well when testing our system in different environments. Competitive products already have this feature.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?