|
Schema Extraction & Scripting
------------------------------
1. (Oracle) Table Scripting: Added support for Table and Column comments
2. (Oracle) Added ability to Script CREATE, REPLACE, ALTER and DROP of Array Types, Table Types, Object Types and Clusters
3. (SQL Server, DB2) Scripting Table Foreign Constraints: Now supports ON DELETE and ON UPDATE clauses.
4. (SQL Server) Script Table CREATE - Support for ROWGUIDCOL
5. (Postgresql 8.0) Function Extraction: Parameter names are now extracted when generating a CREATE or CREATE/REPLACE statement.
6. (MySQL) Script Table CREATE - Support for ENUM and SET datatype
7. Table Scripting: Added "CREATE (Full)" which will script a Table CREATE for the table, constraints, indexes and triggers
Application
--------------------------
1. Aqua Data Studio Look and Feel: Made toolbars use rollover buttons, which also makes the toolbar a little smaller.
2. About Box: Added JDBC Driver tab which displays a list of available JDBC drivers in the JVM and the version numbers.
3. Memory Optimizations: Optimized the reclaiming of memory across query executions by the JVM which keeps ADS consuming less memory over time
4. Aqua Data Studio is now bundled with JRE 1.5 Update 4.
5. Added jConnect 6.0 JDBC driver and set as default driver for Sybase.
6. Added ".PKS" and ".PKB" to Script Filter defaults in File->Options->[General:General]->Script Filters
Server Registration
-------------------------
1. Server Registration: Support for setting Transaction Isolation Level in Advanced tab.
- TRANSACTION_NONE - A constant indicating that transactions are not supported.
- TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented; non-repeatable reads and phantom reads can occur.
- TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads and phantom reads can occur.
- TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented; phantom reads can occur.
- TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads and phantom reads are prevented.
2. (SQL Server)Server Registration : Support for setting quoted_identifier, ansi_nulls, ansi_null_dflt_on, ansi_padding, ansi_warnings in Advanced tab.
3. (Sybase)Server Registration : Support for setting quoted_identifier in Advanced tab.
4. (SQL Server - ODBC, Informix - ODBC, Generic - ODBC) Register Server on Windows: now contains browse button to browse the available ODBC data sources.
Database Support
-----------------------------
1. MySQL 5.0 Support (requires 5.0.10 or above)
- Schema Browser: Added Constraints, Views, Triggers, Procedures and Functions
- Scripting DDL: Added Scripting CREATE/DROP for Constraints, Views, Procedures and Functions
- Visual Editing Schema: Added support to CREATE/DROP Views, Triggers, Procedures and Functions
- Visual Editing Security: Added User Database Privileges: Create View, Show View, Create Routine, Alter Routine, Create User, Execute
2. Support for Informix 10
3. Support for Sybase 15
Printing
-------------------------
1. Printing: Added new printing dialogs with extra capabilities and control to Query Anzalyzer, Procedure Editor and Explain Diagram.
Schema Browser
-----------------------------
1. (Oracle) Schema Browser: Added "Java Classes" folder to list all Java classes available in the schema.
Table Data Editor
---------------------------
1. Table Data Editor: Added a "Edit in Window" command to popup menu so users may edit CLOBs and large text fields with multi-line data.
|
|
Schema Extraction & Scripting
--------------------------------
1. (Sybase) Extract Table: Extracting tables with columns having comments would return multiple columns of the same column having the comments.
2. (Sybase) Script Index CREATE or Table CREATE (Full): Now supports ignore_dup_key, sorted_data, ignore_dup_row in the index CREATE statement.
3. (Sybase) Schema Browser & Constraint & Index columns Exctraction: Browsing and Extracting on a different users objects (other then dbo) would not show up.
4. (SQL Server) Scripting Functions,Procedures&Triggers: In certain cases Scripting would not work if the name of the proc or function was too long.
5. (SQL Server) Schema Browser & Constraint Exctraction: Browsing and Extracting on a different users objects (other then dbo) would not show up.
6. (SQL Server) Table Exctraction: Extracting on a different users tables (other than dbo) would not show up.
7. (DB2) Script "Execute Bind": Sometimes would order parameters in the incorrect order.
8. (DB2) Script Table CREATE: Constraint definitions sometime included info from other schemas.
9. (Informix) Table Check Constraint Scripting: Check constraints with check text greater then 33 characters would produce multiple copies
10. (Informix) Scripting: Table CREATE(Full) was extracting the last trigger in the database, not the trigger for that table.
11. (Oracle) Script Table CREATE: User defined check constraints with names starting with "SYS_C" were not scripted.
12. (MySQL) Script Table: decimals were not scripted with precision and scale.
13. (PostgreSQL) Script Function CREATE/REPLACE: Added support for IMMUTABLE | STABLE | VOLATILE - CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT - | SECURITY INVOKER | SECURITY DEFINER
Schema Browser
----------------------------
1. (Sybase, SQL Server, Sybase Anywhere) Table/View columns where not sorted by ColumnID.
2. (Sybase, SQL Server, Informix): Triggers are now sorted
3. (Oracle) Constraint Browser: Now shows GENERATED and USER DEFINED constraints.
4. (Oracle) Constraint Browser: User defined check constraints with names starting with "SYS_C" were not listed.
5. (Oracle) Procedures & Function nodes under Package and Package Bodies didn't refresh with the "Refresh" command.
6. (DB2) Columns where not sorted in physical order.
7. (SQL Server) - Sorted Jobs and Operators node
8. (Sybase): Store Procedures are now displayed as . instead of just
9. (Sybase Any 9.0) Constraints node didn't list constraints.
10. (MySQL) Added support for objects with names containing "-" in them.
Query Analyzer
------------------------------
1. (Oracle) EXECUTE BIND: Executing a Procedure with a REFCURSOR parameter that was of both IN and OUT value would through exception.
2. (Oracle) EXECUTE BIND: Executing a Procedure with a IN/OUT REFCURSOR would not print resultset correctly.
3. (Oracle) Editor: Added "ELSIF" keyword to syntax coloring.
4. (DB2) Syntax Coloring: Added MERGE and MATCHING to DB2 syntax coloring keywords.
5. Execute Edit would not execute if a single table SELECT had a table name followed by a tab that is not extended.
6. Syntax Coloring: Any string aligned with a quoted string not separated by a space was colored as a quoted text even if it wasn't in the quotes (eg firstname+'lastname')
7. Query Editor: Multi-Line comments were not completely syntax colored as quoted strings
Visual Editing
----------------------------
1. (Oracle) Table Editor: Now shows GENERATED and USER DEFINED constraints.
2. (MySQL) Table CREATE Script: Default values where not being quoted with single quotes.
3. (MySQL) Table Creating/Editing and Scripting: Didn't support precision and scale for INT datatypes and decimal/numerics.
4. Text in Properties Dialog for Function, Procedure, Package, Package Body, Rule, View and Trigger is now copyable able to the clipboard.
5. Text in Preview SQL tab in Visual Editing Forms is now not editable.
Query Results
----------------------------
1. (Oracle) Result columns with nested tables didn't display correctly.
2. (SQL Server) If a query execution returned an error and warnings the warnings were not displayed.
3. Grid Results: Sorting on a string text column where all the data is the same didn't perform very well
4. Grid Results: Columns with no names would not have correctly calculated widths. For columns with no names, the name "column[colposition]" is now displayed.
Server Registration
------------------------------
1. (Oracle) Server Registration (OCI Connections): Added detailed information when JDBC driver doesn't match Oracle Client Libraries.
2. (Oracle) 9i/10g Server Registration: Advanced tab, driver parameters didn't work.
3. Register Server: Passwords with a space as the last characters had space removed when saved.
Application
--------------------------------
1. OSX 10.4: Look and Feel name was changed from "Mac OS X" to "Mac OS X Aqua" which caused ADS to incorrectly set the default Look and Feel to the Aqua Data Studio Look and Feel.
2. Generic ODBC: Connecting to Navision database server would not allow to open a query window.
3. Mnemonics in File Menu: Added _M_ to "Mount Directory" and _U_ to "Unmount Directory".
Table Data Editor
--------------------------------
1. (Oracle) Table Data Editor: Doing an Execute Edit on a fully qualified table . where schema case-sensitivity doesn't match, ADS will not allow to edit the table.
2. (Oracle) Table Data Editor: Extracting Primary Key and Updating table data from a SELECT statement where the table name doesn't use the same case values in the name is now fixed.
Visual Explain
------------------------------
1. (DB2) Explain Plan: Missing icon for TQUEUE operation. TREE_EXPLAIN_SPOOL
2. Explain Diagram: Property-Value table columns are not resized each time the user selects a different node in the diagram.
|
