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.

14 results found

  1. Remember Credentials - Encrypt and Trust Server Certificate Settings

    On the New or Edit Projects popup, when user selects the "Remember Credentials" option for server, also remember the Encrypt and Trust Server Certificate Settings for that server and database combination.

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

  2. Azure MFA support

    Support Azure AD auth using MFA

    87 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…)
    completed  ·  5 comments  ·  Admin →

  3. Date and Time are showing differences when comparing SQL 2016 datatable with SQL 2008 R2

    Time Date Field shows difference due to different formatting - Not easy to work out whether the source and target are identical. Seems like all rows are highlighted.

    1 vote
    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 →
    completed  ·  Mark Jordan responded

    Hi there – this sounds like SDC-2485 (Datetime format in results pane is not consistent) which we think we’ve released a fix for in SQL Data Compare 12.3.0.4373 . Could you check out that version and verify if it does what you expect?

  4. Is there a reason you are using UCS-2 LE BOM encoding instead of UTF-8 (it makes the file twice the size)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →

  5. The "Help > (?) Content" menu item in SQL Data Compare 12 links to the SDC11 docs: http://documentation.red-gate.com/display/SDC12/SQL+Data+

    Just an FYI

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

  6. In V12 Return the Where Clause Filter Icon

    In prior versions when a where clause was created for a table an icon appeared next to the table name indicating a where clause had been applied. The icon no longer appears and when working with multiple tables at once it can be difficult to remember which tables have a where clause applied to them without having to reopen the where clause screen.

    3 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 →
    completed  ·  Mark Jordan responded

    Thanks for the feedback – we’ve added where clause icons again in 12.0.32.3340

  7. Add a project setting that NOT automatically data compares new tables

    When in the xml project file a new table is not available and the table exists in the database sql datacompare now automatically compares this table.

    For a lot of user tables this is not the expected behaviour.
    It would be nicer, if the user can configure if 'unknown' tables will be automatically compared or not.

    So please add a setting that new tables are not included in the compare automatically.

    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…)
    4 comments  ·  Admin →

  8. it would be nice to be able to compare on different column names.

    It would be nice to be able to compare on different column names.

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

  9. only show columns with differences

    Automatically undisplay columns that show no differences what so ever (indicated by not highlighting the columname)
    when inspecting a comparison without recalculating the entire thing. I am bothered about a huge number of columns without interesting
    information, beacuse they don't contain differences at all.
    I only want to focus on the few columns containing the differences (i.e. indicated as colour highlight on the column name field).
    Manual deselection for over 100 columns is not practical.

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

  10. Ignore column when viewing row differences

    Sometimes when viewing row differences, you see a column with differences that appears to be unimportant. It would be nice that you can right-click on this column and have the possibility to ignore that column. In the current system, you have to go to 'Edit Project' -> tab Tables & views -> find the table -> alter 'Columns in Comparison' -> Click dropdown button to get a list of all columns of that table -> scroll to the column you want to leave out of the comparison -> deselect it -> recompare.

    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…)
    1 comment  ·  Admin →

  11. Suppress columns with identical data

    Similar to the option to suppress identical rows, I'd like to suppress columns that are identical on both systems. Especially when comparing tables in a DW environment where we may have 10s-100s of columns I'd rather not scroll across the 100 columns that are identical in order to find the one columns where we have differences.

    Our primary Data Compare application is to validate data changes in th DEV/QA system by comparing against the good PROD data. These comparisons typically involve large tables (100s of columns, millions of rows)

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

  12. Fix the link on the this page (How can we improve SQL Data Compare) that suggests to visit the forums (says forums doesn't exist)

    Fix the link on the this page (How can we improve SQL Data Compare) that suggests to visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=145 (says forums doesn't exist)

    1 vote
    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 →
    completed  ·  Paul Stephenson responded

    Thanks for your report. I’ve updated the link to the correct SQL Data Compare forum URL.

  13. Provide a Start Page

    Like for example Visual Studio, with options to create new project, open project plus a list of recently opened projects. The current behaviour (automatically open -- but do not run -- most recently used project) is counter-intuitive because, seeing a list of servers to pick, I expect it to have started a new project and proceed to trash my existing project!

    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…)
    1 comment  ·  Admin →
    completed  ·  Michelle Taylor responded

    The project list page available as an alternate startup mode described by David Atkinson already provides this functionality – if this isn’t working for you, please submit a new, more specific request!

  14. Accurate floating point comparison in SQL Data Compare

    This was already discussed on the Red Gate forums in 2007:
    http://www.red-gate.com/messageboard/viewtopic.php?t=5875

    As of SQL Data Compare 9.1.0.365, the problem still exists.

    From the forum thread:

    """
    I find that very often, a column containing floating point numbers will show as different [in SQL Data Compare], even though visual inspection of the results [in SQL Server Management Studio] shows that it is the same.
    """

    It's difficult to know if the data in the float column has actually changed, or if it's just SQL Data Compare making an innacurate comparison.

    It reduces my confidence that the data has been synchronized…

    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…)
    3 comments  ·  Admin →
  • Don't see your idea?