Comparing Schemas
Only in DbVisualizer Pro
This feature is only available in the DbVisualizer Pro edition.
While DbVisualizer does not provide a way to fully show the differences between two schemas in terms of objects and data, you can compare different aspects of a schema to another schema one by one.
For instance, to compare the list of tables in one schema with the list of tables in another schema:
- Double-click the schema node for the first schema to open its Object View tab and select the Tables tab,
- Do the same for the second schema,
- Select Compare from the right-click menu in one of the Tables tabs to compare their grid content.
You can do the same for all the other schema object types, such as views and stored procedures. You can also dig deeper and compare the individual objects, such as comparing individual tables.