Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Work with Data > Compare Differences in Data

Compare Differences in Data

Data Diff Viewer allows to compare data contained in the tables and/or result sets from the current or different Editors.

Notes:

To compare differences in data

  1.  Select one of the following:
  2. Customize column mapping and set comparison key.

    Notes:

  3. After comparison, you can view the following information in the Data Diff Viewer window:

    Use this... To...

    Export contents of the Details pane to an Excel spreadsheet.

    Open the Cell Viewer that allows to see cell values. Row Viewer will be opened as well.
    View all compared records.
    View all records (source only, target only and different) except equal.

    (Source only) View records that exist on the source object, but are missing from the target object.

    (Target only) View records that exist on the target object, but are missing from the source object.

    (Different) View records that exist on both objects, but have different values.

    View records that are equal on both objects.

    List the source object columns and the target object columns separately. All source columns will be shown first and then all target columns.

    When cleared source and target object columns are displayed in pairs according to their mapping.

    Hide all columns where values are the same on both objects.
    Navigate between different records. Use to go the next or previous record within the currently selected column.

    Tips:

 

Related Topics

of