The new Visual Editing for Developer forms allows a user to visually CREATE, ALTER and DROP schema objects with easy to use forms. The schema objects supported for all databases include Tables, Views, Indexes, Triggers, Stored Procedures, Functions, Packages, Package Bodies, Sequences, Synonyms/Aliases, Defaults, Rules and Data Types. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.

The new Visual Editing for DBA capabilities allow you to CREATE, ALTER, RESIZE and DROP storage devices for a given database. The schema browser also allows you to navigate the storage structure and to visually alter any of the components of the storage objects and then commit the changes. The visual editing also provides you with an SQL Preview of the SQL which will be used to commit the changes. Storage objects supported include DB2 8.1: Tablespaces, Containers, Oracle: Tablespaces, Datafiles, RedoLogs, Rollback Segments, Controlfiles, Archive Logs, MSSQL Server: Databases, Backups, Sybase: Caches, Dump Devices, Database Devices, Databases, Informix: Databases, MySQL: Databases, PostgreSQL: Databases

Aqua Data Studio's Query Analyzer allows users to generate Visual Explain Plans with or without executing the SQL statements. The explain plan may be displayed in both a tree-table view and in diagram view. Visual Explain currently support Oracle, DB2 and Microsoft SQL Server, providing a common and easy to use interface to all three databases.

Aqua Data Studio now has an enhanced schema extraction and scripting features. Users may now have the option to script the schema definitions to different sources: Current Window, New Window and Save As to a file. Scripting features are also more detailed and provide complete schema definitions for objects, including default values for tables, DDL operations for table columns and more.

The new DBA Object Extraction & SQL Scripting capabilities allow you to browse through all database administration objects and extract the definitions to script the SQL DDL syntax for creating, altering and dropping the objects (including Databases, Tablespaces, Datafiles, Containers, Users, Groups/Roles and Profiles).

Aqua Data Studio provides an Import Tool which allows you to import any delimited text file into an existing table or into a new table. The import wizard provides you with an easy to use interface that guides you through the import process and provides you with a preview of the data that is to be imported before you commit the data.

Aqua Data Studio now provides an enhanced default 'Aqua Data Studio' Look and Feel and adds two new Look and Feels: 'Aqua Data Studio - 3D' and 'Aqua Data Studio - XP' Look and Feel. Look and Feel may be changed in Option->Appearance[Tab]

Aqua Data Studio now provides support for encoding of Eastern Languages for openning and saving scripts and query results. The new encoding types include: "Big5 - (Big5, Traditional Chinese)", "Big5_HKSCS - (Big5 with Hong Kong extensions, Traditional Chinese)", "EUC_JP - (JISX 0201, 0208 and 0212, EUC encoding Japanese)", "EUC_KR - (KS C 5601, EUC encoding, Korean)", "GB18030 - (Simplified Chinese, PRC standard)", "GBK - (GBK, Simplified Chinese)", "ISO2022JP - (JIS X 0201, 0208, in ISO 2022 form, Japanese)", "ISO2022KR - (ISO 2022 KR, Korean)", "SJIS - (Shift-JIS, Japanese)", "TIS620 - (TIS620, Thai)"

SQL Server Named Instances - When registering an SQL Server you may specify in the Hostname text the name of the SQL Server and the Instance name in the format \\ServerName\InstanceName without a port to enable an Instance connection.

Aqua Data Studio now contains a few application level features which will enhance usablity for the user. These features include the following:

Query Analyzer
--------------------
1. Save Results Dialog: Changed "Double quote values" check box to a combo box to specify "Quote Identifier". Values will be quoted and characters in value matching the quote identifier will be escaped.
2. Reading of SQL Scripts in Unicode-16bit didn't work
3. Introduce Value Stub values for dates and time are now the current date and time.
4. Fixed CLOB results display support for all database types. Also enabled Table Editor support for CLOB datatype on appropriate datatypes.
5. Auto-Completion on SELECT statement. If a column name that ended with "FROM" was in the SELECT statement, columns after that would auto-complete. Fixed
6. Auto-completion wasn't working when table name or alias ended with line feed.
7. Query Text Results panel would turn grey after Describing a table and then executing a query.
8. Unclosed single and double quotes in server side comments caused parser to disregard statement separators.
9. Execute Current was not sending Server Side Comments to the server. Comments on Stored Procedures would be lost by Execute Current on creating a procedure.
10. Auto-Completion now supports ansi-join syntax "table1 join table2".
11. Auto-Completion now supports Quoted Identifiers
12. Changed the layout manager of the Multi-Grid query results to have a better look.
13. Saving Results - Data formats of grid results are now saved in the same manner as displayed
14. Grid Formatting of Nulls - Nulls on the grid were not displaying according the the set format
15. Extended "Auto on all Schemas" to include table autocompletion. "Auto on all schemas" will autocomplete on all schemas for both tables and columns.
16. Syntax Coloring: Added more keywords support for all databases.
17. Results Formatting. Option dialog has formatting tab to specify the formatting of numbers and dates
18. Added cancel granularity in the prepare text of a query. Cancelling a query while preparing text will cancel immediately.
19. Options -> Added Optional support for ";" statement separators. Option->General Tab includes a check box to enable this feature.

Table Editor
---------------------------
1. Table Data Editor would hold an open transaction after a "Save Refresh" until the window was closed.
2. Table Editor didn't allow modifications of CLOBs.
3. Table Editor did not work when editing on a SELECT * FROM SCHEMA.TABLENAME. It would contruct the table name incorrectly in the UPDATE, INSERT and DELETE statements
4. The Table Editor now uses the quoted identifiers and schema when generating SQL for changes, when appropriate.

Application
---------------------------
1. Schema Browser Table Columns - Data type precision and scale in the schema browser columns and column autocompletion window now are formatted correctly according to CREATE TABLE syntax.
2. Server Registration: You may now register a server even if you are not able to connect to the server. ADS will prompt the user with the message ... "A connection to this server has failed. Do you wish to register anyway?"
3. About Dialog now contains 2 extra tabs: System and Fonts providing system parameter values and a list of available fonts.
4. Edit Menu: added Redo and Select All commands

OSX
---------------------------
1. Key mappings for Redo, Undo and Select All use the Apple Key instead of the CTRL key
2. CTRL-Click would not open popup window as right click, but CMD-click would. Changed so CTRL-Click opens popup and CMD-Click doesn't

Oracle
--------------------
1. Support to display XMLType columns has been added.

DB2
--------------------
1. Sequence Support: Schema Browser, SQL Scripting and Visual Editing 2. Schema Browser: Stored Procedure & Functions are now sorted
3. DB2 8.1 Schema Browser: Some fix pack versions of 8.1 return the schema with padded spaces.
4. DB2 8.1 Registration: Changed the default port text to 446 instead of 50000, which is the port the JDBC driver attempts to connect to if a port is not included.
5. DB2 8.1 Schema Browser - Added "Containers" node to the tablespace node to display containers of a tablespace.
6. DB2 8.1 Added "Management" node to top level which contains detailed information on Connection and Lock information.

Informix
--------------------
1. Script Table CREATE: Default Values for CURRENT on DATETIME/INTERVAL didn't have the extended date fractions
2. Schema browser & extraction failed to extract "char(x) not null" datatypes
3. Queries on datatypes of "datetime hour to second" failed
4. Datatime variations: formatted correctly and allowed to edit on Table Data Editor
5. Scripting Trigger would script the trigger body out of order.
6. Informix 7.3: Schema Brower: Removed functions and datatypes which are not supported by 7.3.
7. Informix 7.3: Trimmed whitespaces returned on object names.
8. Informix 7.3: Fixed scripting of stored procedures which didn't work on 7.3, and polished scripting of tables, view and indexes
9. Connections do not set the username and password on connection if they are blank, to support trusted connections.
10. Added new connection type of "Informix 7.x-9.x - ODBC" to support Informix through an ODBC datasource.
11. Renamed "Informix Dynamic Server 9.3" connection type to "Informix 7.x-9.x"

MS SQL Server
--------------------
1. MS SQL Server table editor - Enabled ability to edit columns with the NTEXT datatypes

Sybase
-----------------------
1. Schema Browser: Added Storage folder which contains Database Device, Dump Device and Cache browser folders. 2. Connection Dialog: Changed "Sybase 12.5 - TDS 5.5" title to "Sybase 11.x-12.5 TDS 5.5"
3. Connection Dialog: Changed "Sybase ASE 12.5 - TDS 4.5" text in connection dialog to "Sybase ASE 11.x-12.5 - TDS 4.5"
4. Sybase 11.0.x-11.4 - Fixed Schema Browser for Indexes, Constraints, Processes, which didn't display the objects.
5. Sybase 11.0.x-11.4 - Fixed Scripting of Tables, Indexes and Contraints - This version of Sybase doesn't support CASE statements in SQL or index_colorder() built-in function.
6. Sybase: Script Table was not scripting the "NOT NULL" section of a column correctly.

MySQL
--------------------
1. Table Extraction now supports PRIMARY KEY constraints for Table Data Editor, Visual Table Editor and Table Scripting
2. Table editor - Enabled ability to edit columns with the TEXT, TINYTEXT, MEDIUMTEXT and LONGTEXT datatypes

PostgreSQL
--------------------
1. PostgreSQL 7.3+ - Scripting, Auto-Completion/Automation didn't work on certain tables which had columns/indexes removed from them.
2. PostgreSQL 7.3+ - Scripting CREATE of a Trigger Function would fail with new JDBC driver.
3. PostgreSQL 7.4+ - Schema Browser - Moved information_schema. to system table folder
4. Added System Views and System Functions to separate user and system objects.