Online Documentation for Data Comparer for PostgreSQL

Step 3 - Browsing data comparison results


At this step the results of data comparison are represented. You can set options for each of the tables being compared.

 

Step 3 - Browsing data comparison results

 

Table name

The drop-down list of available tables allows you to select a pair of tables to view their data comparison results.

In the Synchronize column the pairs to be compared are checked.

 

Step 3 - Browsing data comparison results_Synchronize

 

The header of the Key field specified at the previous step is marked out with bold font.

 

All data records are divided into several groups distinguished by different colors in the data comparison result grid:

iconGrid_IdenticalRecords identical records are the same in both tables;

iconGrid_DifferentRecords different records are those having different data in one or more fields (text of different records is marked out with bold font);

iconGrid_MissingRecords missing records are the records found in the table of the source database, but not in the table of the target one;

iconGrid_AdditionalRecords additional records are the records found in the table of the target database, but missing in the table of the source one.

 

Note: To view the BLOB data, you can use internal BLOB viewer. To learn more, see Viewing BLOB data.

 

Use the check boxes column to filter records that you want to synchronize. If the record is checked then it will be changed in the target table.

 

You can sort data by the needed column. Simply click a column title to sort the data.

 

Use the following options to filter data:

 

CheckBox View identical records

Select this option to view records which are identical in source dataset and target one.

 

CheckBox View different records

Select this option to view records which vary from the source dataset to the target dataset.

 

CheckBox Missing records

Use this option if records missing from the source dataset should be displayed at the comparison result list.

 

CheckBox Additional records

Enable this option to view records missing from the target dataset.

 

Number of records on page

This value determines the quantity of records displayed as one page in the grid.

 

Use the btnGoToFirstPage btnGoToPreviousPage btnGoToNextPage btnGoToLastPage buttons for navigation through the pages.

To apply changes in filtering or Number of records on page options, you should use the Refresh result list btnRefresh button.

 

Summary

Pressing the Summary button allows you to preview the result of object comparison.

 

Step 3 - Browsing data comparison results_summary

 

If an error occurs, the line is highlighted red. The error type is displayed in the hint that appears when moving the cursor over the error.

 

If necessary, you can iconExportResultList export comparison results to MS Excel, HTML, RTF or MS Excel 2007 using the corresponding dialog. See the Exporting comparison results page to learn more about this feature.

 

 

When you are done, press the Next button to proceed to the next step.