AquaFold
HOME SCREENSHOTS DOWNLOAD DOCUMENTATION SUPPORT LICENSING CONTACT
 

Documentation: Aqua Data Studio 6.5 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 84.7MB) / ads-docs-no-shots.zip (Size: 1.2MB)
  Getting Started
  Installation
  JDBC Drivers
   Oracle 8i
   Oracle 9i
   Oracle 10g
   DB2 7.2
   DB2 8.1
   DB2 9.0
   SQL Server
   Sybase ASE
   Sybase Anywhere
   Sybase IQ
   Informix
   PostgreSQL
   MySQL
  Memory Configuration
  Character sets
  Registering Servers
   MSDE 2000
   SQL Express 2005
   PostgreSQL SSL
  Application
   Browser and Scripting
   Visual Editing
   SQL History and Archive
   Shortcut Toolbar
   Key Mappings
   Key Mapping Assistant
   Custom Keymap Profiles
   Options
   Settings
   New Frame Window
   Details View
   Command Line
  Query Window
   Basics
   Toolbar
   Server Side Comments
   SQL Automation
   Aqua Commands
   Morph to Delimited List
   Results
   Save Results
   Auto-completion
   Popup Menu
   SQL Formatter
   Permissions
   Parameterized
   Pivot Results (Grid and Chart)
   Grid Results (Grid and Chart)
  Editors
   SQL Editor
   Text Editor
   HTML Editor
   XML Editor
   Regular Expressions
  Image Viewer
  Visual Explain Plan
   Basics
   Explain Plan
   Explain Diagram
   Whiteboard
  Procedure/Package Editor
  SQL Debugger
   Sybase Debugger
  Tools
   Table Data Editor
   Schema Script Generator
   Server Script Generator
   ER Diagram
   Query Builder
   Import Tool
   Export Tool
   Execution Monitor
  Compare Tools
   Schema Compare
   Tab Compare
   Directory Compare
   File Compare
   Copy History Compare
   Results Compare
  Oracle DBA Tools
   Instance Manager
   Storage Manager
   Rollback Manager
   Log Manager
   Security Manager
   Session Manager
   SGA Manager
   Server Statistics
  SQL Server DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
   SQL Agent Manager
  Sybase DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
  Source Control
   Subversion
   CVS
Application - 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 refresh the schema browser to show the new object.
ALTER Visual Edit popup menu
ALTER Visual popup menu



CREATE Visual Editor Form
CREATE Visual form

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.
CREATE Visual Editor Form
ALTER Visual form

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.
CREATE Visual Editor Form
ALTER Preview SQL

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-2007 AquaFold, Inc. All Rights Reserved