Aqua Data Studio is a complete Integrated Development Environment (IDE) for database developers. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3) a complete and integrated source control client for Subversion (SVN) and CVS; and 4) a database modeler as powerful as the best standalone database diagramming tools.

New features in v9

Open APIs and AquaScripts

ADStudio breaks new ground for Relational Database tools with the introduction of the Aqua Open APIs, a JavaScript based language called AquaScript and a full-fledged Integrated Development Environment (IDE). Users will now have API access to nearly all of ADStudio's built-in functionality and be able to create fully automated end-to-end solutions.

AquaScripts are executed within ADStudio using the Mozilla Rhino engine. The AquaScript language itself is standardised by Standard ECMA-357 ECMAScript for XML (E4X): A general purpose, cross-platform programming language. Any script executed has full access to the Java API in addition to the Aqua Open API. Scripts may also access any other proprietary or Open Source Java libraries included in the Java Virtual Machine (JVM) classpath.

New database support: Netezza

Native support has been added for Netezza 5.0 & 6.0.

Chart enhancements

New Function Series 'Average': The new function, Average, sums all values in a series and divides that sum by the total number of rows/samples.

New Chart Type 'Map': The new chart type, Map, presents a flat world map with country outlines.

ER model enhancements

Generate ER Model HTML Report: Produces a set of HTML pages that contains a report on all of the Tables, Views, Relationships, Indexes and Regions in the model

MySQL Indexes may be created that use the leading part of column values, using col_name(length) syntax to specify prefix length. Prefixes may be specified for CHAR, VARCHAR, BINARY, VARBINARY, BLOB & TEXT columns. For BLOB & TEXT columns a prefix length must be provided

And more...

Added a permission for SQL Debugger. Determines if a user may open the SQL Debugger on any procedure on this connection

SVN Commit : You may now multi select objects, right mouse click and check/uncheck objects

The Query Results Pane now allows the user to rearrange the result type tabs (Text, Grid, Pivot Grid, Form, etc) in the order desired.

Database IDE

The database query and administration tools allow developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. Aqua Data Studio provides an integrated database environment with a consistent interface for all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from a single application.

Includes:

Query Tool

SQL History/Archive

SQL Debuggers

SQL Formatters

Compare Tools

The suite of compare tools in Aqua Data Studio allows you to view the differences of RDBMS servers, databases and schemas for database tasks with ease. You can further compare the differences of files, directory structures, source control files and full revisions.

Includes:

Database Schema Compare

Query Results Compare

Directory Compare

File Compare

Version Control

Integrated version control provides a complete client for Subversion and CVS repositories, allowing you to manage all source control repositories within one easy-to-use IDE using the Repository Browser.

Includes:

Subversion (SVN)

CVS

Database Modeling

The Entity-Relationship Modeler vastly reduces development time and increases understanding of database schemas and relationships. You can create, explore, detail, and modify database schemas to create fully editable and scriptable diagrams of database relationships and objects.

One licence of Aqua Data Studio provides one user native support for a range of database vendors in addition to generic JDBC/ODBC connection to any number of additional database vendors. A single user may install the software on as many as two machines simultaneously with any combination of supported operating systems. All bundled functionality and multi-language support is available in one installer.

A licence comes with a one year subscription. Subscriptions include customer support, maintenance and upgrades to Aqua Data Studio. When a subscription expires, the licensed user retains a perpetual license for the last version upgrade received. Subscriptions may be renewed at any time. Upon renewal, the new expiration date is extended one year beyond the previous expiration date, regardless of when the licence is renewed.

Subscriptions provide access to customer support, maintenance and upgrades to the purchased software products. An initial purchase of the software product includes a one-year subscription, which may be renewed yearly at 35% of the then current new-license price published on the AquaFold website. When a subscription expires, the licensed user retains a perpetual license to the last version upgrade received. Subscriptions may be renewed at any time. Upon renewal, the new expiration date is extended one year beyond the previous expiration date, regardless of when the license is renewed.