Features and Screenshots - Aqua Data Studio

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.