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

110 results found

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

    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)
  2. 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)
    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)
  3. 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

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

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

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

    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. 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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  13. 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)
  14. 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)
  15. 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)
  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. 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)
  18. 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)
  19. 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)
  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?