Schema and Data Compare

Aqua Data Studio's Schema Compare Tool finds differences in DDL between database objects in two schemas. The Schema Compare Tool also allows comparing database objects of different DBMS vendors. Compare Filters, Syntax highlighting, and save comparison results as HTML provide the ability to visualize data more efficiently. With a rich set of options and flexible features to perform Data Compare, Tabs Compare and Results Compare, users can run reports on production and development environments to analyze differences effectively.



Database Comparison Tools Include:

Schema Compare

The Schema Compare Tool finds differences in DDL between database objects in two schemas. You can compare Tables, Views, Stored Procedures, Indexes, Triggers or any other database object types. The Status of the comparison are shown in a color-coded grid together with the number of differences (Diff Count).screenshots Schema Compare Right Click Menu | Schema Compare

Cross-DBMS Schema Compare

The Schema Compare Tool also allows comparing database objects of different DBMS vendors. Once you initiate a Schema Compare, the tool only loads the common object types that are present in both databases.screenshots Cross-DBMS Schema Compare

View SQL with Syntax Highlighting

You can compare and observe the differences between the DDL of each object set in an SQL editor. The editor automatically color codes SQL keywords, vendor keywords, data types, system functions, system tables, quoted strings and comments to make it easier to read and spot the differences.screenshots DDL Syntax Highlighting

Compare

The Compare feature allows you to compare the DDL of two selected objects belonging to any database schema. Multi select the two objects you wish to compare, right click and select the option Compare. The comparison result is displayed in an editor with the deleted, changed or added items.screenshots Compare Object DDL

Tabs Compare

You can easily do a side-by-side comparison of any opened editor windows in Aqua Data Studio. If you have more that two editor windows open, a Select Tabs to Compare window is displayed and you can choose from the tabs list.screenshots Compare Open Document Tabs

Results Compare

The results of queries generated in multiple Query Analyzer windows can be compared. The differences of table/view data are shown in a grid with highlighted rows and columns that contain the differences.screenshots Compare Query Results

Compare Data

The data contents of objects that exists in two schemas can be compared. A Compare Data operation can be launched directly from the Schema Comparison results dialog by clicking the Compare Data button adjacent to the Filter Options at the top of the results. The differences of table/view data are shown in a grid with highlighted rows and columns that contain the differences.screenshots Compare Data | Compare Data Results

Compare Filters

You can add filters to the results of a comparison. Create new filters with the Filter Option and Enable/Disable them to get your preferred comparison results view.screenshots Schema Compare Filters

Save Comparison Results as HTML

The results of a schema comparison can be saved as an HTML report. Once the results are displayed, click the Save button located at the top left of the pane.screenshots Save Comparison Results as HTML

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2014 AquaFold, Inc. All Rights Reserved.