Versions Compared

Key

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

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

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 Aqua Data Studio menu bar > Tools > Compare Tools
Image Modified

From the Schema Browser, you can perform File Compare and Schema Compare
Image Modified

From the Files Browser or Projects Browser, you can perform File Compare andDirectory Compare.
Image Modified

With the right-click action on an open tab, you can perform Tab Compare.

Image Modified

Copy queries and then launch Copy Compare from the Aqua Data Studio menu bar Tools > Copy Compare.
Image Modified

Comparison Result

...

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.  
Image Modified 
Files viewed within the Repository Browser can also be compared with their previous versions.
Image Modified

Comparison Filters

...