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.
...
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
...
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
...