Oracle DB2 iSeries DB2 LUW SQL Server Sybase ASE Sybase Anywhere Sybase IQ Informix PostgreSQL MySQL Apache Derby

Aqua Data Studio for Oracle

Aqua Data Studio is a management tool for the Oracle relational database with administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects and database storage, as well as maintain database security. An integrated query tool allows you to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio further provides import and export tools to move data easily both in and from different data formats, as well as in and out of the Oracle database. Integrated within these tools are the Oracle SQL Debugger, and a Repository Browser with full source control clients for CVS and Subversion (SVN).

 Aqua Data Studio - Administration and Query Tool
Oracle Features
Schema Browser / Visual Editing / DDL Object Scripting
          Browsing   Visual Editing   DDL Scripting 
         - Schema
                 - Tables x x x
                 - Views x x x
                 - Synonyms x x x
                 - Sequences x x x
                 - Indexes x x x
                 - Triggers x x x
                 - Packages x x x
                 - Package Bodies x x x
                 - Procedures x x x
                 - Functions x x x
                 - Java Sources x
                 - Materialized Views x
                 - Materialized View Logs x
                 - Dimensions x
                 - Object Types x x
                 - Array Types x x x
                 - Queue Tables x
                 - Table Types x x x
                 - Refresh Groups x
                 - Database Links x
                 - Clusters x x x
         - Management
                 - Sessions
x x
                 - Database Locks
x
                 - Locks by Session ID
x
                 - Locks by Object x
         - Storage
                 - Controlfile x x
                 - Tablespaces x x x
                 - Datafiles x x x
                 - Rollback Segments x x x
                 - Redo Log Groups x x x
                 - Redo Logs x x
                 - Archive Logs x x
         - Security
                 - Users x x x
                 - Roles x x x
                 - Profiles x x x
         - Mountable Script Browser in Schema Browser
         - Object filtering
 
Procedure & PL/SQL Editor
         - The Procedure Editor provides a compilation and execution environment for the development of procedures, functions, and packages. Users can compile procedures, view results and jump to errors to assist in the refinement of their executable code.
 
Query Window
         - MultiTab Mode / SplitPane Mode
         - Query Popup Window
         - SQL Script Editor
                 - Cut/Copy/Paste/Undo/Redo/Select All/Find/Replace
                 - To Lower Case/To Upper Case/Goto Line
                 - Configurable tab expansion, tab size and space conversion
         - Query Window
                 - Parse Script
                 - Execute Script
                 - Execute Current Statement
                 - Execute Edit
                 - Execute Explain Plan
                 - Control of Auto-commit/Commit/Rollback
         - Auto Completion
         - Auto Describe
         - Shortcut Toolbar
         - Local SQL Permissions
         - SQL Formatter
         - SQL Automation
                 - Introduce Insert/Update/Delete/Select Statements
                 - Introduce Columns/Qualified Columns/Value Stubs
                 - Comment/Uncomment statements/lines
         - Syntax Coloring
                 - Color configuration for SQL 92/99 Keywords, Oracle specific keywords, data types,
                     system functions, system tables, quoted strings, comments
         - Results
                 - Max results & max column retrieval configurable
                 - Text (configurable display of SQL Statement, query statistics, warning headers)
                 - Text History
                 - DBMS_OUTPUT
                 - Grid (configurable alternating colors) and Grid Chart Results
                 - Explain Plan
                 - Client Statistics (Time stats: total processing, client processing, server wait,
                     parse, execution)
                 - Pivot Results (With Pivot Grids and Pivot Charts)
         - Save Results
                 - Delimited Data
                 - INSERT Statement
                 - XML Document
                 - HTML Document
                 - Excel Worksheet
 
Scripts Browser
         - Multi-mount point script browser
         - Filterable script folders
 
Table Data Editor
         - Visually insert/modify/delete/undo recordset results
         - Preview SQL changes before commiting
         - Save changes to database or SQL statements to file
         - CLOB/Large Text editor
 
Visual Explain Plan
         - Explain Grid
                 - Color coding for Critical Path, Critical Node and Critical Operator
                 - Customizable columns
         - Explain Diagram
                 - Color coding for Critical Path, Critical Node and Critical Operator
                 - Zoom In/Zoom Out
         - Explain WhiteBoard
 
SQL History and Archive
         - History storage of executed SQL statements and scripts, stored in a directory that can be analyzed for statistics and performance, or for audit purposes (Sarbanes-Oxley).
 
Tools
         - Import Tool
                 - Import delimited data files
                 - Import to database or INSERT statements
         - Export Tool
                 - Export to delimited data or INSERT statements
         - Schema Script Generator
                 - Script a complete or partial database to file, including CREATE, DROP DDL and INSERT DML.
         - Server Script Generator
                 - Server Script Generator allows a user to generate SQL scripts for server objects such as databases, users, roles, alerts, jobs, tablespaces etc.
         - ER Diagram Generator
                 - Generate an ER Diagram from a current database schema with a few clicks of a button.
         - Compare Tool
                 - Schema Compare
                 - Tab Compare
                 - Directory Compare
                 - File Compare
                 - Copy Compare
                 - Result Compare
 
ER Modeler
         - Create, Edit and View database schema relationships using entity relationship diagrams .
 
DBA Tools
         - Instance Manager
         - Storage Manager
         - Rollback Manager
         - Log Manager
         - Security Manager
         - Session Manager
         - SGA Manager
         - Server Statistics
 
Configurable Look and Feel
         - Aqua Data Studio
         - Aqua Data Studio - 3D
         - Aqua Data Studio - XP
         - Mac OSX (only Mac OSX)
         - Windows
         - Windows Classic (only Windows XP)
         - Metal
         - CDE/Motif
 
Debugger
         - SQL Debugger
 
Source Control
         - Subversion (SVN)
                 - Repository Browser
         - CVS
                 - Repository Browser
 
 
 OS Support
Download Windows
Download Linux
Download OSX
Download Solaris
Download Java Platform

Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact
Copyright © 2001–2008 AquaFold, Inc. All Rights Reserved.