ADS is a query and administration tool that allows developers and administrators to do common tasks easily on any of the supported database platforms . I downloaded the software from the AquaFold Web site and installed it in just a few minutes on a Windows XP machine with no problems. I then tested the product against SQL Server and Oracle databases. The product comes equipped with all the JDBC drivers required to connect to the supported databases, along with a generic JDBC and generic ODBC driver. However, the documentation does say that updated drivers from the vendor may be required in specific configurations.
For the developer, ADS includes a nice query analyzer that features syntax highlighting, automation, auto-completion and multi-grid result sets that can be sorted. The automation and auto-completion are a huge benefit, in my opinion, because these features will save a considerable amount of typing (and typos) as you create SQL code. The query analyzer's automation feature saves a large amount of typing by generating the majority of your SQL, leaving you to fill in the specifics with the auto-completion feature. As you type, auto-completion brings up the tables, views, synonyms and their columns. To make auto-completion work properly you will have to learn to separate your SQL statements with "GO" or a "/," which the program requires. This does take some getting used to, since it is specific to the product. One shortcoming I noticed when using ADS with SQL Server is that when auto-completion inserts a table with a space in its name, it does not automatically put brackets around it. Aside from this, I found automation and auto-completion a huge time saver.
The product also comes with a useful feature that lets you visually create or modify any schema objects, along with functionality to script these objects. Another feature I found particularly useful is the table editor, which allows you to make changes to the data without immediately updating the database. When you're finished making updates, you can see your additions, updates and deletions in different colors. From there you can commit the changes to the database or save the changes to a script, which can be quite useful. For example, if you need to make changes to a development database before production, you can make the changes in the table editor in development and then run the saved script in production when ready.
Ability to manage heterogeneous RDBMSs from a single interface
Auto-completion and automation are a big time saver when writing SQL statements
Supports myriad operating systems