Page History
Aqua Data Studio provides six compare tools to easily compare database schemas, schema objects, queries, query results, files, directories, clipboard contents, and version control history.
Compare Tools
This table describes the compare tools.
| Compare Tool | Description | |
|---|---|---|
| Schema Compare | Identifies differences in DDL between database objects in two different schemas. | |
| Schema Synchronization | Identifies differences in DDL between database objects in two different schemas and synchronizes the DDL of the selected target database objects to match that of the source database. | |
| Tab Compare | Identifies differences in the content of the application tabs. |
|
| Directory Compare | Identifies differences between contents of the directories and supports synchronizing selected or all differences of the selected file. |
|
| File Compare | Identifies differences in the content between two text-based files. |
|
| Copy Compare | Identifies differences in the content of the clipboard history. |
|
| Results Compare | Identifies differences between two result sets obtained from either the same query or two different queries. |
|
Launch Compare Tools
From the Aqua Data Studio menu bar > Tools > Compare Tools. 
From the Schema Browser, you can perform File Compare and Schema Compare. 
From the Files Browser or Projects Browser, you can perform File Compare andDirectory Compare.
With the right-click action on an open tab, you can perform Tab Compare.
Copy queries and then launch Copy Compare from the Aqua Data Studio menu bar Tools > Copy Compare.
Comparison Result
Colored background highlighting and font bolding is used to indicate differences in comparison results. Aqua Data Studio highlights the comparison between the schemas, tabs, files, directories, clipboard history, and results in different colors. Differences are highlighted in the default pink (deleted), purple (changed), or green (added). You can assign new colors from the Options dialog.
Version Control
Compare tools are also thoroughly integrated within Aqua Data Studio. When a version-controlled file is modified, Aqua Data Studio displays inline diff indicators on the Annotation bar. The inline diff indicator allows live comparisons with the local source control repository to be run as editing continues. A green diff indicator () signifies addition and a blue diff bar indicator (
) signifies replacement. An arrow
signifies the deletion of lines.
Files viewed within the Repository Browser can also be compared with their previous versions. 
Comparison Filters
...