Viewing the row differences
Published 13 December 2022
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.