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 modeler as powerful as the best standalone database diagramming tools.
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.
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.
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 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 schemes to create fully editable and scriptable diagrams of database relationships and objects.
Changelog for this release:
Bug : SQL Server : Added support for COLUMNSTORE keyword in extraction and scripting
Bug: PostgreSQL : In PostgreSQL 9.1 and above, support extraction & scripting of "UNLOGGED" option for create table
Bug : MS SQL Server : In MS SQL Server 2008 and above, support extraction/scripting of table compression
Bug : Query Analyzer Apache Derby : Query Analyzer for Apache Derby now displays current schema correctly and uses combo box to allowing changing of schema
Bug : DB2 iSeries : Procedure extraction of set options was a very slow join. Separated extraction into separate queries.
Bug : Mac OS X : Corrected incorrect path in datastudio-osx.sh
Bug : Mac OS X : Put in workaround to get ADS running on 1.6.0_51 jre
Pentium II / 128 MB RAM