Visuall Data Comparison

DBTYP.NET Studio gives users ability to easily observe and quickly locate all differences visually. Full color marked differences grid enables users to inspect differences between table rows for selected table. Each row shows all compared columns.

Unlike to other solutions, where differences are shown as side-by-side columns in one row, DBTYP.NET Studio shows differences in a side-by-side rows one below another where comparison key columns are shown first.

As an sample we take a screen shot below which we pick from comparison of Employees table from two Northwind databases. You can easily identify following:
Target table contains two rows which not exist on a source table: with EmployeeID equal to 15 and 116, both shown in a pink.
Totally 3 rows has been modified (with EmployeeID 1, 2 and 3). These rows are shown one above each other, in light pink and light green.
At the end, 6 rows are present on source and missing on target database - EmployeeID 4, 5, 6, 7, 8 and 9.

If you need to identify exact changes in modified rows, you can do that, by selecting thosse columns, and in context menu choose, Mark differences as it is shown below:

All differences between rows will be presented in red.