View differences in records

The Data Viewer and Editor dialog shows record details. To display the Data Viewer and Editor dialog box, double-click a record in the Row Differences grid.

Alternatively, select Data Viewer and Editor in the View menu on the main toolbar or press Ctrl+W, R.

Data viewer

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

In case a value exists in only one of the data sources, you can view it and edit if necessary in the Data Viewer and Editor dialog box.

Data viewer only target

If the value is an image, click the Image View button to view the details, for example:

Data viewer picture

With the help of the Data Viewer and Editor toolbar, you can select the required format to display data.

Search value details

For string values, you can search value details by right-clicking the Row Differences grid, and then selecting Find in the context menu. In the Find box of the Find and Replace window that opens, type your search text, configure search options and click Find Next or to find the next match.

Alternatively, to get the Find and Replace window, click the Search icon Search icon on the Row Differences grid toolbar.

To copy the value details for use in another application, double-click the required record, then in the Data Viewer and Editor window that opens, select the value you want to copy, right-click the selection and finally click Copy from the context menu.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?