Aqua Data Studio
| Aqua Data Studio | |
|---|---|
| Basic data
|
|
| developer | aquafold |
| Publishing year | 2002 |
| Current version | v20.0 (May 2019) |
| operating system | Windows, Mac & Linux |
| programming language | Java |
| category | visual database query and management tool |
| License | proprietary |
| https://www.aquafold.com | |
Aqua Data Studio is a visual database query and management tool developed in the Java programming language . It is for the platforms Windows , Linux and Mac OS X are available. It allows the user to formulate, edit and execute SQL scripts. In addition, database structures can be graphically displayed and changed. The program can already connect to the most important relational databases, such as SQL Server , MySQL , PostgreSQL , Oracle , DB2 , Sybase and Informix , as well as via ODBC and JDBC connections. This allows users and developers to perform various tasks on different databases at the same time, and all of this under a single graphical interface. The program is remarkable in that it can run on the 3 major desktop platforms and connect to a large number of the important database backends . Up to version 2.0 Aqua Data Studio was freely available for all user categories, with version 4.7 a license requirement was introduced for commercial users from version 6.0 this is subject to a license fee for private as well as academic and commercial users.
features
Query Analyzer / Window
Aqua Data Studio's extensive Query Analyzer assists the user with syntax highlighting and autocompletion when developing and testing SQL scripts. Other features of the Query Analyzer include SQL automation, auto-describe (automatic SQL describe of objects) and sortable table results. The Query Analyzer can also be used to bind variables on the client side in order to call up stored procedures or functions with parameters. The query window provides two operating modes to separate editor and results as SplitPane or MultiTab.
Schema browser & visual editing
The graphical browsing capabilities visualize the structure and dependency of the database schema with a click of the mouse. The schema browser also allows you to visually edit any schema object to CREATE, ALTER or DROP on it. Visual editing supports tables, indexes, procedures, data types and various other schema objects. The visual editor also provides an SQL preview of the commands it will execute.
Schema extraction & DDL scripting
The graphical browser allows the extraction of structure definition of all schema objects and thus the SQL DDL and DML statements for the schema objects in script form (for tables, views , triggers, stored procedures and functions).