SQL Data Compare 14

Viewing the row differences

The lower (Row Differences) pane displays a side-by-side listing of values for the tables and views you have compared. To display the lower pane, click a table or view in the list of tables.

By default, all rows with differences are selected for deployment. Use the Include check boxes to include or exclude the rows.

 Rows that contain differences are displayed with a shaded background.

 Values that are different are displayed with a darker shaded background.

 Values that exist in one database but do not exist in the other are displayed with a shaded, patterned background.

In the example above, for the row where WidgetId is 2:

  • Description is the same in both databases so the data is displayed in gray text
  • The Picture values are different so they are displayed with the darker shaded 

Shading on the column names also indicates differences. A column name with shading indicates values that are different; a column name with partial shading indicates values that only exist in one of the data sources.

Note that:

  • The lower (Row Differences) pane cannot display values for tables or views that could not be compared. For more information, see Tables and views that cannot be compared.
  • If you have cleared the Show identical values in results project option, SQL Data Compare does not show rows that are identical and a warning symbol  is displayed.
  • If you have selected the project option Compress temporary files, you will be unable to sort the comparison results by clicking on a column header.For more information, see Setting project options.

Searching the data

To search the values, in the Find box, type your search text, then click  or  to find the next or previous match. If the Find box is not already displayed, right-click and click Find.

To show the next or previous difference, use the arrow buttons or press the shortcut keys; the values that differ are shown with a green background.

Viewing the data

The Viewer dialog box displays value details.

For more information, see Viewing the data.


Didn't find what you were looking for?