Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This table describes the compare tools.

Compare Tool Description
Schema CompareIdentifies 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 CompareIdentifies differences in the content of the application tabs.

Directory CompareIdentifies differences between contents of the directories and supports synchronizing selected or all differences of the selected file.

File CompareIdentifies differences in the content between two text-based files.

Copy CompareIdentifies differences in the content of the clipboard history.

Results CompareIdentifies differences between two result sets obtained from either the same query or two different queries. 

...

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.

...

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.

...