Database IDE
- Workspace Environment
- Docking & Windowing Framework
Query & Analysis Tool
- Pivot Grid
- Charting Tool
- Auto completion
- Visual Explain
- Multi Results Format : Text, Grid, Pivot, Form
- SQL Formatter
- SQL History
Database Object Navigator and Visual Editing
Browse database objects and visually edit them with a few simple clicks. Create, Alter and Delete without having to write a line of code.
SQL Debuggers
- Oracle Debugger
- Sybase Debugger
- DB2 Debugger
- SQL Server Debugger
SSH Terminal
Register and connect to as many SSH servers as you need and run commands in a tabbed window GUI. For added security it also has a:
- Key Generator
- Key passphrase Agent
Compare Tools
- Schema Compare
- File Compare
- Text Compare
- Directory Compare
- Results Compare
ER Modeler
The Aqua Data Studio ER Diagram modeler and generator is used in designing, editing and reverse engineering database schemas. Tables, views, relationships and constraints are converted to shapes, lines, nodes and vectors so that complex abstract database objects and processes can be viewed in a coherent ER diagram.
Visual Query Builder
The Visual Query Builder lets you select database tables directly from the GUI, and then specify columns to retrieve, joins, sorting options, filtering criteria and other query parameters in a grid format. Along with selecting tables and adding query parameters, the Visual Query Builder will generate a complete SQL statement that can be viewed, copied and executed from the Visual Query Builder dialog window.
Version Control
- Subversion
- CVS
- Git
- Perforce
Table Data Editor
Aqua Data Studio provides a Table Data Editor that allows you to edit the result-set of an executed query on a table using a convenient graphical interface. This makes it easy to alter data and add or delete rows using an editable, Excel-like grid.
Import & Export Tools
The Import and Export tools allows data of different formats to be imported and exported to and from databases, tables, objects and files.
Scripting & Open APIs
- Project Environment
- Debugger
Database Administration Tools
- Oracle
- DB2
- MS SQL Server
- Sybase ASE
- MySQL
For the databases listed above there are Instance, Storage, Security, and Session Managers. For Oracle there's also a Rollback, Log, and SGA Manager. For MS SQL Server there's an additional Agent Manager.
Database Support
- Oracle - 11g, 10g, 9i, 8i
- DB2 iSeries V5R3, V5R4, V6R1, V7R1
- DB2 LUW - 9.7/9.x/8/7
- DB2 z/OS - V8/V9
- MS SQL Server - 2012/2008/2005/2000/7/MSDE
- Sybase ASE - 15.5/15/12.x/11.x
- Sybase Anywhere - 11/10/9/8
- Sybase IQ - 12.x, 15
- Teradata 12/13
- Aster nCluster 4.0/4.5
- Netezza 5.x/6.x
- ParAccel Analytic Platform 3.5/3.1
- Informix IDS - 11.x/10/9.x/7.x
- PostgreSQL - 9.x/8.x/7.x
- MySQL - 5.x/4.x/3.x
- Apache Derby 10.x
- Generic JDBC
- Generic ODBC
Operating System Support
- Windows
- Linux
- OSX
- Solaris
- Java
Language Support
- Chinese (Simplified)
- Chinese (Traditional)
- Czech
- Danish
- Dutch
- English
- Finnish
- French
- German
- Greek
- Hindi
- Italian
- Japanese
- Korean
- Norwegian
- Polish
- Portuguese
- Portuguese (Brazil)
- Russian
- Spanish
- Swedish
