How to view data comparison results
After you have compared data, a Data Comparison document will appear with Source and Target connections displayed in the upper part of the window and data comparison results displayed in two grids. The top grid lists all the compared tables and views with values indication the quantity of rows that are different, identical, existing only in Target or only in Source. The bottom grid contains the corresponding data records of the selected database object in the top grid. The records are grouped by their status and displayed on separate tabs. They are Different Records, Only in Source, Only in Target, Identical Records, and Conflict Records. It appears only in case any conflict records exist. The shortcut menu of the Data Comparison document and its top menu provide a number of options to manage the comparison results. The status bar in the bottom of the grid shows the number of differences per a column.
Database objects can be filtered by differences. You can select what objects to show: objects with different, identical records, only in source or only in target records.
To view the specific kind of tables:
- Click the down arrow near the Filter button on the Comparison toolbar.
- Select the corresponding option in the appeared menu. Several options can be selected at the same time.
Note
In case a table has both different and identical records, it will be visible, independently of the selected options: Different or Identical.
You can also filter Incorrectly mapped objects and Correctly mapped objects.
To clear filtering:
- Click the down arrow near the Filter button on the Comparison toolbar.
- Select All from the appeared menu.
The bottom grid allows you to view data differences between the corresponding tables or views. Select a table in the compared database object grid, and the data of these tables appears in the tabs below.
The Identical Records tab contains a grid with data rows that are identical and there is no need to update such records in target. Other tabs contain an additional column with check boxes in the grid. This column is named as action, that will be executed when synchronizing data - Update, Delete, or Insert. By selecting or clearing these check boxes you can control which rows will be affected with data synchronization. This column will not hide when scrolling grid.
Note
Incorrectly mapped objects are displayed with Caution icon instead of check box in the Data Comparison document. The data of such database objects are not compared. Zero count will be displayed for all kinds of records. Objects with no data to synchronize, with only identical records or with no records at all, are displayed without check boxes.
The Only in Source and Only in Target tabs contain grid with Insert and Delete columns respectively and data rows, that are stored only in the table of the source and of the target database respectively. the Different Records tab contains grid with the following columns.
- Column with check boxes.
- Comparison key columns. Their value is the same for the compared tables.
- Other table columns. Source columns and target columns are grouped in pairs and marked as Source and Target. When the values of the corresponding columns are different, this pair is highlighted with bold.
If a non-unique custom comparison key was chosen for any table or view, the fifth column in main grid and the fifth tab Conflict Records appear. The tab consists of two grids containing all records with non-unique values of the comparison key from the corresponding database. These records cannot be synchronized.
If you cleared the Update, Delete, or Insert column check boxes in some tables, you may view only tables with selected records or only tables without selected records. To filter tables, click the down arrow near the Filter button on the Comparison toolbar and select the corresponding option in the appeared menu.
To refresh data comparison results, click the Refresh button on the Comparison toolbar. To view long text or binary fields, use the Data Viewer and Editor window.
Download dbForge Studio for SQL Server and try it absolutely free for 30 days!
Want to Find out More?
Overview
All features
Request a demo
