Database Compare Suite™

Detailed data comparison

You can compare data in 2 selected tables or views so you can exactly know, which data cells have different values.

  1. Create a new project or open an existing one.

  2. Select the operation scope by choosing the desired nodes on metadata trees.

  3. Click Compare in Details button in the Data Operations panel. You will get to the matching page.

    Here you can adjust objects matching if needed.

  4. Click the Options button at the bottom right-hand corner of the central window. You will get to the Data comparison options page.

  5. Click the Sorting keys button at the bottom right-hand corner of the central window to proceed the operation. You will get to the Sorting keys selection page.

  6. Click the Run button at the bottom right-hand corner of the central window to get the result.

    detailed data comparison result

    As a result, you’ll see all different values in two tables or views.
    If you just need to get sure that two tables are equal (have no differences), go to the simpler Data comparison operation or use the Fast data comparison operation.

  7. If you can’t clearly see the differences in this table, double click on the selected line to open a ‘Detailed row comparison’ window.

    As a result, you’ll see all different values in two tables or views.

  8. Click the Restart button at the bottom of the central window to restart the detailed data comparison operation using the same scope, matching rules, and preferences, while reloading data and metadata from the databases.

  9. Click the Export button at the bottom right-hand corner of the central window to save the comparison result into the .csv file.

  10. Click the Close button at the top right-hand corner of the central window to close the Data comparison window.


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].