Simple structure compare

Team Edition lets you compare two database objects side by side and see how their structures differ. You can compare databases, schemas, or tables, then view the changes in a clean, lightweight report. Under the hood, Team Edition reads metadata directly from both objects, and highlights structural differences.

Structure comparison process

1. In the Database Navigator, select two objects or multiple matching objects you want to compare

   Info

   You can compare databases, schemas, tables, or other matching containers.

2. Open the context menu

3. Choose Compare/Migrate -> Simple Structure Compare

4. The wizard opens with the selected objects and the Compare settings

   

   Setting	Description
   Skip system objects	Skips system objects returned by the driver. System folders and system tables aren't included in the comparison.
   Compare expensive properties	Enables deeper comparison beyond structural metadata. Deep comparison may take longer on large objects.
   Compare only structure (ignore properties)	Compares only structural metadata. All properties are skipped, except DDL-based ones when script comparison is enabled.
   Compare scripts/procedures	Includes object definition text for objects that expose DDL (views, triggers, procedures, etc.).

5. Review the settings, then click Next to configure the Report settings

   

   Setting	Description
   Show only differences	Filters the final report to show only objects and properties that differ. Matching entries are hidden.
   Output type	Selects how to generate the report: open it in the browser or save an .html file to a folder.
   Directory	Folder where the HTML report is saved when file output is selected. Disabled if output type is browser.

6. Click Compare to generate the report

7. Depending on the Output type, the report either opens in your browser or saves to the selected folder