Aqua Data Studio

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;
4) A database modeller as powerful as the best standalone database diagramming tools.

OS Support: * ADS for Windows * ADS for Linux * ADS for OSX * ADS for Solaris * ADS for Java Platform

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

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.
• Query Tool
• SQL History/Archive
• SQL Debuggers
• SQL Formatter
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.
• Subversion (SVN)
• CVS

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.
• Database Schema Compare
• Query Results Compare
• Directory Compare
• File Compare

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