Schema extraction and SQL DML and DDL scripting is a new feature in the schema browser which now allows you to extract schema definitions by scripting SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database objects (including Tables, Views, Triggers, Stored Procedures and Functions).
Pop-up Query Analyzer
A new Popup Query Analyzer allows you to open multiple query windows side by side to compare scripts and query results. The Popup Query Analyzer provides the same multi-threaded functionality and results capability as the tabbed Query Analyzer.
SQL History Window
The SQL history feature provides complete and easy access to the history of all SQL statements and scripts executed. A dockable history window allows you to view and retreive all previously executed SQL statements and scripts.
Oracle DBMS_OUTPUT Support
The Query Analyzer window now includes support for Oracle’s DBMS_OUTPUT package. By activating the DBMS_OUTPUT results, all DBMS_OUTPUT is printed in the Text Results of any SQL statement that is executed.
Text History Results
The Text History Results option for the Query Analyzer provides a text result panel which displays the text results and the previous results, offering a continuous history of results. You can specify the max # of lines in the text history results.
Printing SQL Scripts and Results
The Query Analyzer windows can now print SQL scripts and query results.
Opening and Saving Scripts and Query results in different Encoding types
Support for new Encoding types has been added when opening and saving scripts and saving query results. When opening and saving, encoding options are provided for ASCII, UTF-8, TF-16 and other popular encoding types.
Server Side Comments
The ability to specify Server Side Comments in SQL scripts has been added to the Query Analyzer. Server Side Comments allow for comments to be sent with the SQL statement to the server for execution. This feature is needed in the case of adding comments into Stored Procedures. Options for specifing which comment types (eg --, // or /* */) are treated as Server Side Comments for each database are available in the options dialog.
Enhanced Query Analyzer
The enhanced Query Analyzer includes several new features such as more complete keywords for syntax coloring, detailed status of query execution with a real-time timer, support for synonyms and identiy columns in auto-describe, synonym support for auto-completion/ table editor/sql automation, line-divider for ’Windows (CR/LF)’ or ’Unix (LF)’ when saving results and support for Oracle’s TIMESTAMP column.
Enhanced Schema Browser
The enhanced Schema Browser now allows the user to set the current database on a new Query Analyzer to the currently browsed database. It can provide the corresponding objects on synonym and alias nodes, the corresponding base data type on user defined data type nodes, corresponding tables for index nodes, columns for index nodes with sort order, new top level nodes for triggers and index and much more.
Enhanced Table Editor
An enhanced Table Editor now supports unique constraints. Editing a table which does not have a primary key will make the Editor alternatively use any unique constraint for the primary key generation. The Editor also supports editing of synonyms and aliases for Oracle, DB2 and Informix.
Optimized Memory Consumption and Performance
Aqua Data Studio has been optimized for faster query speeds with up to 600% speed gains. The memory consumption for query results has also been optimized to keep memory low and prevent bloating across many queries.
Additional Database Support
Aqua Data Studio now provides full support for PostgreSQL 7.3 including schema support. A new ODBC connection type for Microsoft SQL Server also provides support for Trusted Connections using Windows Authentication.
Application Bug Fixes
OSX ------------------------- 1. OSX CTRL/Apple Hot Keys - All CTRL hots keys are now mapped to Apple hot keys. The CTRL-C/X/V/Z and Delete keys in the editor work correctly. 2. OSX - The header on the Grid column looked funny. Fixed, and also changed icon to a black arrow.
Query Analyzer ------------------------- 1. Query analyzer - double clicking on a word containing underbar characters now highlights the entire word. 2. Informix column auto-complete was padding the name to 18 characters. Now the column name is trimmed. 3. MySQL v 4.0 database names are case sensitive, and 3.x are not. Made ADS current database support for MySQL case sensitive. 4. Script Parser removed comments within quotes (eg ’LK--%’, the parser would remove --%’), now fixed. 5. When closing a query window and prompted to save the file, if Save As is selected but then cancelled, the query window will closed. Now the window does not close. 6. Introduce Columns, Qualified Columns, Value Stubs on SQL Server and Postgresql didn’t work when operating on a table that wasn’t owned by the user logged in. 7. Saving a file when closing a Query Window would fail. Fixed. 8. Saving a file with Save As or creating a new file, would not append a default ’SQL’ extension if the user didn’t specify an extension. Fixed. 9. Execute Edit worked on the entire current statement. Now, it works on the selected text first ... and the current statement if nothing is selected. 10. If a script is being modified and another script is double-clicked for open, there is no prompt to save the current script. Fixed.
Query Results ------------------------- 1. "Copy" in the popup menu of the Grid Results only worked when there was one grid result. 2. Removed Square Icon from first column of the grid results that specified the grid was not sorted. 3. When saving query results, the encoding used is saved as the default encoding for future saves. 4. Select All and Copy to clipboard from grid results didn’t work very well with large resultsets. Fixed. 5. The first click on grid results column now sorts the column in ascending order instead of descending. 6. "Message" Results tab did not have the display set to the last appended message in the document. Now display is always set to the bottom. 7. Sybase Anywhere - Column and Table names are trimmed for metadata queries in auto-completion and schema browser for Sybase ASA 6.x
Application ------------------------- 1. The initial focus at application startup is now the schema tree. 2. If OS Environment doesn’t contain USER_HOME variable then ADS would not be able to save any settings and would not run. ADS now prompts the user to set the USER_HOME. 3. Now accounts for null JDBC Driver MetaData when connecting to a server. 4. When registering a Server, the server name allowed users to specify special characters. The server name must be a valid filesystem name. This would cause ADS to fail. ADS now prompts the user for a valid filesystem name. 5. Option Dialog didn’t come up if there was a problem retreiving Fonts from the OS (specifically on OSX). Now it does. 6. SQL Server and Sybase allow for Databases with Spaces, but ADS didn’t support them ... now ADS supports them. 7. Top File Menu (Automate) - Converted Mnemonic to "A" - "Execute Parse" hot key changed to Ctrl-Alt-A 8. Made the top toolbars non-floatable. 9. ADS was not cancelling any running queries when exiting. ADS now cancels all running queries before exiting. 10. Informix Server Registration - If database registered was not sysmaster, then Query window would not open. Now it does.
Table Editor ------------------------- 1. In Table Editor, if a cell was changed, then cleared, then changed again, the data would be set to null. 2. If Table Editor is invoked on a SELECT statement which doesn’t select the Primary Key, then execption was thrown when trying to save changes. Warning is now displayed. 3. Table Editor on Sybase only allows a save once, and then fails on any other attempts. 4. Table Editor for MySQL 4.0 didn’t work for tables that were not all uppercase ... because of MySQL’s case sensitivity. 5. Table Editor on SQL Server had editing of the TEXT datatype disabled ... now it is enabled. 6. Table Editor didn’t work on PostgreSQL 7.3 and above. 7. If no Primary Key or Unique Constraint is defined on table being edited, then user is not prompted to select one. Now they are prompted.
Schema Browser ------------------------- 1. Informix 7.3 - Index folder for tables in Schema Broswer did not show the Indexes. It does now. 2. Generic-JDBC driver - Schema Browser would not show Tables and Procedures if the database didn’t support Schemas, now fixed. 3. DB2 Schema Browser - Table Index Node did not include all indexes. Now it does. 4. Sybase Stored Procedure Parameter node didn’t show parameters of the stored procedures. Now it does.
Last updated by swissarmyknife(*)
on May 24, 2010 5:05 PM