Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager

Schema (Diff) Difference Tool

-Provides a user with a graphical interface depicting differences between schemas from the same or a virtually any different database type (Oracle, DB2, Sybase, SQL server, Informix, My SQL and PostgreSQL).

-Provides a list of object types from which the user can compare the selected objects. For example, the user can pick only functions, or only tables and views, or all of the existing object types to compare them in the two databases.

-Allows the user to then see the difference between object DDLs.

-Displays graphically the selected objects which are seen as being identical, different, non-existant or changed in some way in the counterpart database.

-There is a top panel and a bottom panel. The top panel depicts differences in database objects. The top panel colors are: green-green (not different), pink-white (not different), pink-white (existing in the first database but not in the second database), white-green (existing in the second database, but not in the first database) half-green/half-pink (existing in both databases but different).

-If you click on the object, the difference will be depicted in detail on the bottom panel as a difference in their DDLs. The legend (pink, green, purple) explains those differences from the bottom panel. The objects highlighted in pink represent the objects that still exist in one database that have been deleted from the other database. The objects highlighted in green represent the objects that have been added to one database and not the other database. The objects highlighted in purple are the objects that exist in both databases but have been changed in some way in one or the other or both.

Schema Diff Selection Schema Diff
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved