
This does take some getting used to, since it is specific to the product.

To make auto-completion work properly you will have to learn to separate your SQL statements with "GO" or a "/," which the program requires. As you type, auto-completion brings up the tables, views, synonyms and their columns.

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. 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.
Aqua data studio 14 full drivers#
However, the documentation does say that updated drivers from the vendor may be required in specific configurations.įor 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 product comes equipped with all the JDBC drivers required to connect to the supported databases, along with a generic JDBC and generic ODBC driver. I then tested the product against SQL Server and Oracle databases. 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.

ADS is a query and administration tool that allows developers and administrators to do common tasks easily on any of the supported database platforms.
