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 and Directory 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 (
Files viewed within the Repository Browser can also be compared with their previous versions.
Comparison Filters
Aqua Data Studio provides various comparison filters and options. When files, queries, or tabs are compared, the comparison functions down to the character level within each. When schemas are compared, the level of comparison granularity can be set by the user for database schema object types as desired. For even more control over the comparison, you can apply filters to the comparison result. The results of all comparisons can be saved as HTML for storage or sharing.