Aqua Data Studio 8.0rc1

Aqua Data Studio 8.0rc1 delivers an automatic, reliable database developer's complete Integrated Development Environment (IDE). The IDE provides three major areas of functionality: A) Database query and administration tool, B) a Suite of compare tools for databases, source control and filesystems and C) a complete and integrated source control client for Subversion (SVN) and CVS.

Major Features:

1. OS Support:  ADS for Windows  ADS for Linux  ADS for OSX  ADS for Solaris  ADS for Java Platform
2. 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)
3. 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.
4. 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.
5.  Query Tool
6. SQL History/Archive
7. SQL Debuggers
8. SQL Formatter
9. Database Schema Compare
10.  Query Results Compare
11. Directory Compare
12.  File Compare
13. 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.
14. 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.
15. Subversion (SVN) client  
16. CVS  
17. ER Modeler

Enhancements:

• 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.