SQL Data Compare 12

Viewing the data

The Viewer dialog box displays value details. To display the Viewer dialog box, double-click a value in the lower (Row Differences) pane.

For example, if a value exists in only one of the data sources:

If the row exists in both databases but the values are different, the values are shown side-by-side, and the differences are highlighted.

Use the  Previous and  Next buttons to go to the previous or next line with a difference.

To view the individual spaces, select the Show white space check box.

If the value is a binary value, such as an image, click the Binary Data link to view the details, for example:

You can select the required format in which to display the data.

Searching the value details

For string values, you can search the value details by right-clicking, and clicking Find. In the Find box, type your search text and click  or  to find the next or previous match. If there are no further matches, the Find box changes color. If the value details are displayed side-by-side, to search the value details in the other data source, click Find on this Side.

To copy the value details for use in another application, select the data, right-click, and then click Copy. Alternatively, right-click, click Select All, then right-click, and click Copy.


Didn't find what you were looking for?