Aqua Data Studio is a complete Integrated Development Environment (IDE) for database administrators, software developers and business analysts. 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.
RDBMS Support: (Oracle – 11g, 10g, 9i, 8i) (DB2 iSeries V5R3, V5R4, V6R1) (DB2 LUW – 9.7/9.x/8/7) (DB2 z/OS – V8/V9) (MS SQL Server – 2008/2005/2000/7/MSDE) (Sybase ASE – 15/12.x/11.x) (Sybase Anywhere – 11/10/9/8) (Sybase IQ – 12.x, 15) (Teradata 12) (Aster nCluster 4.0) (Informix IDS – 11.x/10/9.x/7.x) (PostgreSQL – 8.4/8.x/7.x) (MySQL – 5.x/4.x/3.x) (Apache Derby 10.x) (Generic JDBC Platform) (Generic ODBC)
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.
he 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.
Version 8.0 of Aqua Data Studio now includes improved memory optimization methods than previous versions. One of these techniques is a memory compression method for optimizing resultsets which includes redundant data such as numeric data. Querying for large results in data warehousing environments with large quantities of numeric data will yield dramatic memory reductions. Long term use of Aqua Data Studio in these environments will keep memory usage low and in turn keep performance of the application high. The optimizations are most apparent in the Query Analyzer, Query Builder, Saving Results and Exporting of data.