Skip to content

Comparing Tables

Only in DbVisualizer Pro

This feature is only available in the DbVisualizer Pro edition.

You can compare the structure of two tables, and also their DDL, their data and other information in their Object View tabs.

Comparing the structure

Select both tables in the Databases tab, right-click and select Compare Tables. The differences in columns, indexes and constraints are shown, and DbVisualizer can write a script that makes one table like the other. See Comparing Schemas, Databases and Tables.

Comparing the DDL, the data or other grids

To compare the DDL of two tables:

  1. Open the DDL tab of each table.
  2. In one of them, right-click and select Compare, and select the other one.

To compare the data of a table with another table or a query result:

  1. Open the Data tab of the table, and the Data tab of the other table or the result in SQL Commander.
  2. In one of them, right-click and select Compare, and select the other one.

You can compare other grids in the Object View tabs in the same way, such as the Columns or Primary Key tabs. For how the differences are shown, see Comparing Data.