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
Visual Editing - Aqua Data Studio provides visual editors for database schema objects, database storage objects and security objects. By navigating the schema browser a user may locate any object and by right-clicking the mouse get a popup menu with the CREATE, ATLER and DROP commands for the object. By selecting the desired operation the user may visually CREATE, ALTER or DROP the object. Once the object has been designed in the form, the user may click the "Ok" button at which time the form will generate an SQL statement(s) which are executed on the database to create the object and refreshes the schema browser to show the new object.
Syntax Coloring of Changes - When ALTERing an object, the visual forms don't make any changes to the database until the user clicks the "Ok" button. Instead, the forms will keep track of the changes the user is making until the user decides to commit the changes. To help the user remember what changes he/she has made, the form colors the changes so the user knows what attributes have been changed, added or dropped. All dropped attributes are colored red. Changed attributes are blue, and added attributes are green.
SQL Preview - At any point while CREATEing or ALTERing an object, the user may click on the SQL Preview tab to view the SQL statements that the visual form will use to make the changes in the database.

Visual Editing for Schema forms allows a user to visually CREATE, ALTER and DROP schema objects with easy to use forms. The schema objects supported for all databases include Tables, Views, Indexes, Triggers, Stored Procedures, Functions, Packages, Package Bodies, Sequences, Synonyms/Aliases, Defaults, Rules and Data Types.

Visual Editing for Storage capabilities allow you to CREATE, ALTER, RESIZE and DROP storage devices for a given database. The schema browser also allows you to navigate the storage structure and to visually alter any of the components of the storage objects and then commit the changes.

Storage objects supported include:

  • DB2 8.1: Tablespaces, Containers
  • Oracle: Tablespaces, Datafiles, RedoLogs, Rollback Segments, Controlfiles, Archive Logs
  • MSSQL Server: Databases, Backups
  • Sybase: Caches, Dump Devices, Database Devices, Databases
  • Informix: Databases
  • MySQL: Databases
  • PostgreSQL: Databases

    • Visual Editing for Security allows a user to visually CREATE, ALTER and DROP security objects with easy to use forms. The security objects supported for all databases include Users, Roles, Profiles, Logins, Server Roles and Object/Column Permission.

    Below is a list of databases and the security objects supported:

  • DB2: Users, Roles, Object Permissions, Column Permissions
  • Informix: Users, Roles, Object Permissions, Column Permissions
  • MySQL: Users, Object Permissions, Column Permissions
  • Oracle: Users, Roles, Profiles, Object Permissions, Column Permissions
  • Sybase Anywhere: Users, Roles, Object Permissions, Column Permissions
  • Sybase: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions
  • MS SQL Server: Logins, Server Roles, Users, Roles, Object Permissions, Column Permissions
  • Postgresql 7.4/8.0: Users, Roles, Object Permissions
  • Postgresql 7.2/7.3: Not Supported
    		•
    Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved