Comparing Schemas

You can compare different aspects of a schema to other schema.

For instance, to compare the list of tables in one schema with the list of tables in another schema:

1. Double-click the schema node for the first schema to open its Object View tab and select the Tables tab,
2. Do the same for the second schema,
3. 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.