Aqua Data Studio description
Create SQL scripts and execute them with ease
Aqua Data Studio is a SQL editor and developer utility which enables developers to easily create, edit, and execute SQL scripts as well as browse database structures.
Aqua Data Studio provides an Integrated Database Environment with a single consistent inferface to all major relational databases. This allows the DBA or developer to tackle multiple tasks simultaneously from one application.
The Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test scripts including detailed client statistical information and multi-grid results.
Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema at a click of a mouse. It also includes the ability to save your query results in many formats including HTML and XML.
Here are some key features of "Aqua Data Studio":
· Connect, Explore and Develop
· With this version of Aqua Data Studio you can now natively connect to and use Greenplum: one of the major Big Data players in data warehousing. If you've used Aqua Data Studio to work with PostgreSQL, then you'll have no problem getting accustomed to the tools we provide you for working with Greenplum.
· Color Themes for Any Aesthetic
· A comprehensive update to our Grid and Pivot Grid Charting Tools means you can now rapidly customize charts by using one of more than a dozen pre-built themes. New Chart Toolbar buttons let you show and hide chart elements, fit your chart to window and much more.
· Query, Code and Get Results
· Native support for Vertica now brings Aqua Data Studio's full toolset to anyone working on Vertica. We're glad to bring our database developer IDE to the powerful data warehousing Vertica platform.
· More Intuitive Git Tools
· Our Git menus have been reorganized to make it easier to find the tools you need to Push, Pull, Branch and tag. Create and Mount a Git Repository in a single step. Simply clicking on a Git mount in the Schema Browser lets you see its Branch Label in the application Status Bar.
· Access the most widely deployed embedded open source database. We now support the most commonly embedded database engine, SQLite, providing you all the tools you've come to expect from Aqua Data Studio.
Database Upgrades and additional Enhancements:
· More DB Version Support
· Connect to Sybase ASE 15.7 and Sybase IQ 15.4. We've also added full support for MySQL 5.5, DB2 z/OS 10 and Netezza 7.
· Aqua Data Studio's sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results.
Schema Browser & Visual Editing:
· Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.
Schema Extraction & DDL Scripting:
· Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions).
Table Data Editor:
· A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the 'Execute Edit' button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table.
· 1GHz x86 Processor or above (Intel/AMD)
· Minimum 256 MB or RAM
· Minimum 100 MB of Disk space
· 14 days trial
· Nag screen
What's New in This Release: [ read full changelog ]
· Bug : In some cases execution of current statement by Cntrl+Enter runs other statement than under cursor
· Bug : Unbalanced quote in literal breaks autocompletion
· Enhancement : Import option date format autocompletion case sensitivity
· Enhancement : Postgres 9.1+ -> create/alter sequence support
· SQL History not highlighting where the query in the Query Pane is coming from upon SQL History relaunch
· Bug : postgresql -> schema script generator -> sequences -> extraction query fixed
· Enhancement : Use case sensitive date format autocompletion
· Ehhancement : db2 iSeries -> get current schema -> extraction now comes from database / Set & Get Current Schema
· Bug : debugger - right click context menus not appearing ( only see "copy" )
· Bug : sybase ase -> script constraint -> check -> was appending check to constraint definition even when definition had check in it already.
· Enhancement : postgresql -> extraction -> pg_authid is no longer
· Enhancement : sybase ase -> dba tools -> session manager -> p...