Documentation 8.0
Aqua Data Studio 8.0
Supported RDBMS Servers
1. Installation
    1.1 Minimum Requirements
    1.2 Installing Aqua Data Studio in Windows OS
    1.3 Installing Aqua Data Studio in Linux OS
    1.4 Installing Aqua Data Studio in Mac OS
    1.5 Launcher & Memory Configuration
    1.6 Interface Language, Fonts & Character sets
    1.7 Charts and OpenGL/JOGL Configuration
    1.8 Application Logs & Support Information
    1.9 Configuration & Connection files
2. Registering a Database Server
    2.1 Oracle
    2.2 Oracle OCI
    2.3 DB2 iSeries
    2.4 DB2 LUW
    2.5 DB2 zOS
    2.6 MS SQL Server
    2.7 Sybase ASE
    2.8 Sybase Anywhere
    2.9 Sybase IQ
    2.10 Informix
    2.11 Teradata
    2.12 Aster nCluster
    2.13 MySQL
    2.14 PostgreSQL
    2.15 Apache Derby
    2.16 Generic JDBC
    2.17 Generic ODBC
3. JDBC Driver Configuration
    3.1 Oracle 8i JDBC Drivers
    3.2 Oracle 9i JDBC Drivers
    3.3 Oracle 10g JDBC Drivers
    3.4 Oracle 11g JDBC Drivers
    3.5 DB2 iSeries JDBC Drivers
    3.6 DB2 z/OS JDBC Drivers
    3.7 DB2 LUW 7.2 JDBC Drivers
    3.8 DB2 LUW 8.1 and DB2 UDB 8.2
    3.9 DB2 LUW 9.0 and DB2 UDB 9.5
    3.10 SQL Server JDBC Drivers
    3.11 Sybase ASE JDBC Drivers
    3.12 Sybase Anywhere JDBC Drivers
    3.13 Sybase IQ JDBC Drivers
    3.14 Informix JDBC Drivers
    3.15 Teradata JDBC Drivers
    3.16 Aster nCluster Drivers
    3.17 PostgreSQL JDBC Drivers
    3.18 MySQL JDBC Drivers
    3.19 Apache Derby JDBC Drivers
    3.20 SQLite JDBC Drivers
    3.21 Firebird JDBC Drivers
4. Workspace and Docking Framework
    4.1 Menus and Toolbar
    4.2 Shortcuts Toolbar
    4.3 Schema Browser
    4.4 Scripts Browser
    4.5 Details View
5. Query Analyzer - SQL Tool in ADS
    5.1 Invoking the Query Analyzer (CTRL+Q)
    5.2 Using the Query Analyzer
    5.3 Query Analyzer and its Environment
    5.4 Server Side Comments
    5.5 Parameterized Scripts
    5.6 Displaying Results of Queries
    5.7 Saving Query Results
    5.8 Tips and Tricks
    5.9. SQL Automation
        5.9.1 Insert, Update, Select
        5.9.2 Introduce Columns and Value Stubs
        5.9.3 Morph to Delimited List
        5.9.4 Formatting Statements
        5.9.5 Auto Completion
        5.9.6 Aqua Commands
    5.10. Charting Grids and Pivot Grids
        5.10.1 Working with Grids and Pivot Grids
        5.10.2 Working with Enhanced Charts
        5.10.3 Scripting Charts
        5.10.4 Chart Options
        5.10.5 Function Series
    5.11. Visual Explain Plan
        5.11.1 Using Explain Diagrams
        5.11.2 Sample Query Tuning Demo
6. SQL History (CTRL+ ALT+H)
7. Query Builder Tool in ADS
    7.1 Building Queries
    7.2 Workspace Reference
8. GUI Tools for Database Objects
    8.1 Creating Databases
    8.2 Creating Tables
    8.3 Creating Constraints
    8.4 Creating Indexes
    8.5 Creating Views & Triggers
    8.6 Creating Aliases & Synonyms
    8.7 Creating Storage Objects
    8.8 Multi Scripting Objects
9. Tools and Features
    9.1 How to Import Data using ADS
    9.2 How to Export Data using ADS
    9.3 Generate SQL Scripts using ADS
    9.4 Table Data Editor
    9.5 Server Script Generator
    9.6 Using Object Search in ADS
    9.7 Comparing two Database Schemas
    9.8 Using the Visual Explain White Board
    9.9 Using the Execution Monitor
    9.10 Generating ER Diagrams
10. Procedure, Function & Package Editor
11. SQL Debugger
    11.1.1 Oracle Debugger
    11.1.2 DB2 Debugger
    11.1.3 MS SQL Debugger
    11.1.4 Sybase Debugger
12. ER Modeler in ADS
    12.1 Notation and Normalization
    12.2 Creating Tables
    12.3 Creating Indexes
    12.4 Creating Constraints
    12.5 Creating Relationships & Subcategories
    12.6 Adding Notes and Regions
    12.7 Saving and Exporting an ER Model
    12.8 Forward Engineering
    12.9 Reverse Engineering
    12.10 ER Modeler Demo
    12.11 Converting ER Models DB to DB
13. Version Control in ADS
    13.1 Using a Subversion Repository
    13.2 Using a CVS Repository
    13.3 File Search in Version Control
14. Database Administrator Tools
    14.1 ORACLE DBA Tools
        14.1.1 Server Statistics
         14.1.2 Rollback Manager
         14.1.3 Log Manager
         14.1.4 Session Manager
         14.1.5 Instance Manager
         14.1.6 Storage Manager
         14.1.7 Security Manager
         14.1.8 SGA Manager
    14.2 SQL SERVER DBA Tools
        14.2.1 Instance Manager
        14.2.2 Session Manager
        14.2.3 Security Manager
        14.2.4 Storage Manager
        14.2.5 SQL Agent Manager
    14.3 SYBASE DBA Tools
        14.3.1 Instance Manager
        14.3.2 Session Manager
        14.3.3 Security Manager
        14.3.4 Storage Manager
    14.4 MySQL DBA Tools
        14.4.1 Instance Manager
        14.4.2 Session Manager
        14.4.3 Storage Manager
        14.4.4 Security Manager
    14.5 DB2 for LUW DBA Tools
        14.5.1 Instance Manager
        14.5.2 Session Manager
        14.5.3 Storage Manager
        14.5.4 Security Manager
15. Compare Tools in ADS
    15.1 File Compare
    15.2 Results Compare
    15.3 Directory Compare
    15.4 Tab Compare
    15.5 Schema Compare
    15.6 Copy History Compare
16. Editors & Viewers
17. Aqua Data Studio OPTIONS
    17.1 General Options
    17.2 Editor Options
    17.3 Compare and Results Options
    17.4 Query Analyzer Options
    17.5 Scripts and Results Options
    17.6 Visual Explain Options
    17.7 Formatter Options
    17.8 Permissions and Registration Options
    17.9 Key Mapping Options and Key Assist Tool
    17.10 Command line

1.8 Application Logs & Support Information

The View Log window provides three tabs for examining logs, errors and actions taken by Aqua Data Studio. This is useful for troubleshooting issues and support questions, and monitoring server connection status.

  • Error log: Displays a running list of errors gathered after the View Log has been launched. These errors accumulate only as long as the View Log is open. The Save To Clipboard button makes it easy to include specific log contents in an email or document. The quickfilter within the Error Log allows filtering by log level.

  • Console: This can intercept stdout, stderr, and uncaught exceptions. Functions the same as a command prompt or terminal for the operating system for viewing errors. Incorporating this in the application means not having to leave the application to launch a terminal or console during troubleshooting. The Save To Clipboard button makes it easier to include specific console contents in an email or document. 

  • Archive: Collection of all of the Error Logs as text files. Each may be opened by double clicking, which launches a text editor. The quickfilter allows quick searching of contents. The columns within the Archive are sortable by clicking on the column headers.

  • Startup Log: Displays information on Aqua Data Studio's most recent launch, including version number, date, time, Java version, memory use, system CPU count and file encoding.

By default, a rolling file logger is always enabled to ~/.datastudio/datastudio.log

This logger is configured to write up to 3 files of up to 300KB each, using "%d{M/d HH:mm:ss.SSS} %C{1}.%M %m%n layout.  (Logging month/day).

The logger can be turned off by placing logger.config file into ~/.datastudio directory.  This file overrides built-in configuration and offers the developers or end users virtually unlimited configuration choices.

 

Example Config File

# root logger
log4j.rootLogger=all, stdout, FILELOG

# console appender
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%C{1}.%M %m%n

# file appender
log4j.appender.FILELOG=org.apache.log4j.RollingFileAppender
log4j.appender.FILELOG.File=c:/datastudio.log
log4j.appender.FILELOG.MaxFileSize=20MB
log4j.appender.FILELOG.MaxBackupIndex=5
log4j.appender.FILELOG.layout=org.apache.log4j.PatternLayout
log4j.appender.FILELOG.layout.ConversionPattern=%d{HH:mm:ss.SSS} %C{1}.%M %m%n

 

Aqua Data Studio Support

Documentation & Knowledge Base
  Online Docs: http://docs.aquafold.com/ads/8.0/index.html
  Browse Public Mailing List: http://groups.yahoo.com/group/aquadatastudio/
   
Direct Email Support
  Email: architect (at) aquafold.com
 
Public Mailing List
  Browse Archive: http://groups.yahoo.com/group/aquadatastudio/
  Subscribe: Send a blank message to aquadatastudio-subscribe@yahoogroups.com
  Unsubscribe: Send a blank message to aquadatastudio-unsubscribe@yahoogroups.com
 
Ongoing Development with user feedback
  Ongoing development of Aqua Data Studio is done in an open community through our mailing list. Anyone may participate in discussions on future features and anything related to Aqua Data Studio. Or you may just monitor the on going discussions. New builds with bug fixes and new features are released every few weeks for continuous feedback.
 
  Browse Archive: http://groups.yahoo.com/group/aquadatastudio/
  Current Change Log: http://download.aquafold.com/download/changelog.txt
  twitter: http://twitter.com/aquadatastudio
  Latest Builds: http://download.aquafold.com/download/
  Update Instructions: Update Instructions Here