Page History
...
- Connect to a database.
- On the Aqua Data Studio menu bar, click Tools > Compare Tools > Schema Synchronization.
To launch the Schema Synchronization Tool from the Aqua Data Studio Servers pane
- In the Servers pane, connect to a database, and then select the source and target schemas. The schema you select first is the source schema and the second is the target schema.
- Right-click a selected schema and then click Schema Synchronization.
| Info |
|---|
| Alternatively, you can launch both the schema compare and schema synchronization tools by selecting two versions of the same database from the Aqua Data Studio Servers pane. For example, to compare Oracle 10g & Oracle 12c, select and right-click these versions from the Servers pane and then click Schema Compare/Synchronization. |
...
You can compare and synchronize all schemas by selecting <All Schemas> option from the source and target drop-down lists. However, Sybase ASE Server does not allow synchronization of all schemas.
To change the source or the target servers, click Change Server for the respective server. To swap the source and target servers, click .
| Info |
|---|
| Synchronization across different DBMS vendors is not supported. If your purpose is to compare and synchronize, then ensure that you select servers of the same DBMS vendor. For example, synchronization between Oracle 12g & Oracle 10g is supported, but synchronization between Oracle 12g & SQL Server 2016 is not supported. |
...
You can select all objects or specific objects for schema comparison and synchronization. Different databases have different schema objects.
When you select a schema object, all objects of that type are listed in the Objects area. These objects are by default selected for comparison. The objects in the left pane are the source schema and on the right are the target schema. You can filter objects using the Search text box. You can also use different toolbar actions to select or clear objects from schema compare and synchronization. This table lists these actions.
| Icon | Actions |
|---|---|
| To check all selected schema objects. | |
| To clear the selected schema objects. | |
| To invert the last selection. |
...
| Right-Click Action | Description |
|---|---|
| Checks all selected schema objects. | |
| Clears the selected schema objects. | |
| Inverts the last selection. | |
| Show All (Clear Filter) | Displays all objects by removing the search filter applied to the objects. This action applies to Objects area. |
| Check All | Selects all schema objects. |
| Uncheck All | Clears all selected schema objects. |
| Select All | Highlights all the listed schemas and its object names. |
| Invert Selection | Inverts the list of selected schema objects. |
...
| Schema Synchronization Tool | Schema Compare Tool |
|---|---|
In the schema synchronization tool, this option is selected and read-only. During schema compare, it extracts dependencies of the selected schema objects. These dependent objects from the selected source and target objects can be viewed in the default viewer of the Review Dependencies tab. |
Include Object Permissions
...
You can use these policies for ignoring whitespaces, empty lines, and case sensitivity for the generated DDL scripts. Four of the options offered to perform case insensitive (ignore case) comparisons and the other four options perform case sensitive comparisons. The Script Ignore Policy option is used in conjunction with the Ignore case for the object definition option. For example, if you select the Ignore case for the object definition check box, then you should select a case insensitive option from the Script Ignore Policy option. The comparison engine first performs a case insensitive comparison between the source and the target object names and then compares the content of the DDL based on the selected Script Ignore Policy.
Do not ignore
When you choose this option, the comparison engine performs a case-sensitive comparison and does not trim the occurrence of whitespaces and empty lines in both the source and target scripts, to determine whether both the scripts are equal. All differences can be synchronized during schema synchronization.
...
The objects alignment options allow you to control the source and target schema alignment in the script. 
Include Schema Name
...
To choose a quote identifier, on the Aqua Data Studio menu bar > File > Options > Scripts > <Database_Name> > Quote Identifier.
Recommended Options For All Databases
...