...

The schema compare status in the Schema Compare Results tab is tool-dependent. 

If you click Cancel this operation, the Schema Compare Results dialog is displayed. You can choose to cancel the current compare operation, abort and start a new compare, or continue with the existing compare operation.

...

In the Schema Compare Results tab, the objects you had selected in the Schema Synchronization Tool are grouped together according to their state. On choosing a row in the Schema Compare Results tab, the SQL Differences pane displays the DDL differences for both schemas in different color codes.

 
This table describes the columns in the Schema Compare Results tab.

This table describes the color code and results for each state.

State	Description
Image Modified	The source and target schema objects are equal.
Image Modified	The object exists in both the source and target schemas but they are different.
Image Modified	The object exists in the source schema but not in the target schema.
Image Modified	The object exists in the target schema but not in the source schema.

Toolbar Actions

This table describes the Toolbar actions in the Schema Compare Results tab.

Icon	Description
Image Modified	Refreshes the schema compare result.
Image Modified	Allows changing data sources and adding or removing schema objects and schema options from schema compare. When you click this icon, Aqua Data Studio retrieves a snapshot of the schema synchronization dialog cached in memory and launches the Schema Synchronization Tool. See Attachment. If data cached in memory is out-of-date, then Aqua Data Studio will show an error message for DDLs that could not be generated. Therefore, we recommend performing a refresh before editing the comparison result.
Image Modified	Exports the schema compare result to HTML. You can preview the result in your default browser after Aqua Data Studio saves the file at the specified location.
Image Modified	Exports the schema compare result to Excel.
Image Modified	Compares data contained in the selected source and the target objects. You can only compare the data of a table or a view.
Image Modified	Filters schema objects.
Image Modified	Synchronizes schema objects you have selected from the schema compared result. For more information, see Schema Synchronization. Info The Schema Compare Results tab, when launched from the Schema Compare Tool, shows Synchronize Schema in a read-only state. On mouse-hover, a message is displayed in the tooltip, prompting you to launch schema synchronization if you want to use synchronize schemas.
Image Modified	Displays schema objects by grouping them together according to their type of differences or lists schema objects alphabetically without grouping them. For more information, see Group by.
Image Modified	Allows searching for schema objects by object name, schema name, or schema object type. Supports a case-sensitive or case-insensitive search and search by match found options.
Image Modified	Allows expanding and collapsing the result view. Info This action is only available when you choose Type of difference action from the Group by drop-down list.
Image Modified	Allows multiple object selection (Image Modified), removal (Image Modified), and inversion (Image Modified) of the last action. Info You will not see these icons if you have launched the Schema Compare Results tab from the Schema Compare Tool.

Refresh

When you click , Aqua Data Studio queries the target database to retrieve a new list of schema objects based on the object types specified in the Schema Compare Results tab. The refreshed result in the Schema Compare Results tab can be categorized according to these scenarios.

...

You can apply type and state filters on the compared schema objects. To apply a filter, on the Schema Compare Results toolbar, click .  If you are viewing schema compare result in the Type of difference view, then you will only see Type Filter in the Schema Compare Filter window.

 If you are viewing schema compare result in the No Groups view, then you will see both Type and State filters in the Schema Compare Filter window.

...

This table describes the right-click actions for selecting schema objects for synchronization. Right-click action is not available in the Schema Compare Tool.

View SQL Script Differences

On selecting an object, you can view the source and target differences in different color codes in the SQL Differences pane. The script differences are shown in the default viewer where the source and target scripts are positioned side-by-side.

If you change the default display to the Unified viewer, then each source schema is followed by a target schema. It merges the common information and highlights the differences between the scripts.

...

The colored blocks in the SQL Differences pane highlight the differences in the SQL script. The Default viewer displays colored blocks on the left and right scroll bars whereas the Unified viewer displays colored blocks on the right scroll bar.

Colored Blocks	Description
Image Modified	This block of SQL statements is different between the source and the target object.
Image Modified	This block of SQL statements is present only in the source object.
Image Modified	This block of SQL statements is present only in the target object.

If you want to change the default color codes, then on the Aqua Data Studio menu bar, click File > Options > Compare, and then choose the color code to change (Additions, Deletions, Changes).

...