May 21st, 2012· #6945 : Bug : Paste to Window doesn't replace selected text.
· NONE : Bug : MySQL : Storage Manager : auto_increment column in system tables is of bigint(21) but only Integer was used.
· NONE : Bug : QueryBuilder : Sorting on a column which had a Group By would add a ASC/DESC on the Group By clause
· NONE : Improvement : Teradata : Query Analyzer : Added label for "sid" to indicate session id.
April 25th, 2012· #6859 : table data editor -> negetive numeric values translated to string values in sql statement
April 25th, 2012· #6760 : Export data to Excel with 3+ columns sorted, and the last column has repetitious data will cause missing rows
· #6652 : Parameterized script not prompting for all parameters when double single quote combination involved.
· #6754 : Added option to Perforce client configuration for charset.
· NONE : Query Window : "Change Server" action needed to set the database combobox to the current database after reconnect.
· NONE : Query Window : Enhanced error message on "No route to host" errors and login errors.
March 17th, 2012· Bug: NaN values for Float and Decimal where displayed incorrectly
· Bug: Export data on views is now extracting views as views and not as tables.
· Bug: Support multi-file opening for Query Windows with multi-file selection.
· Bug: (DB2 iSeries) Added QSYS2 system schema to qualify tables for extraction of view information.
· Bug: (nCluster) Added few more datatypes support to ER modeler
· Bug: (Sybase IQ) Removed syscomments from View Extraction Query as it had no effect.
· Bug: (Teradata) Indicating no database in registration would still set the property in the JDBC URL causing the connection to fail.
February 8th, 2012· Bug : Opening script with "Open in..." opens in query window, but database context is incorrect
· Bug : In a server mounted folder, multi-selected files, right mouse click -> Open will open in editor instead of query window
· Bug : Sybase ASE script DDL of check constraint longer then 255 char is truncated
· Bug : Save Results to INSERT with CREATE statement on nCluster fails
· Bug : nCluster returning Boolean for BIT datatypes
· Improvement : File mounted folder, multi-select, right mouse click should have "Open in..." action
· Add option in File->Option->General->General->[Execute Trimmed Statement in Scripts]
February 1st, 2012· Bug : Converting ER Model from MySQL to MySQL will lose precision
· Bug : Schema object filter fails in German language
· Bug : Schema Compare filter should show empty list if filter results are empty
· Bug : "Check syntax" when creating a trigger should not actually create the trigger. Regression bug.
· NONE : Bug : Table Data Editor - Added support for Binary Primary Keys
January 18th, 2012· Bug: Query Analyzer As prompted login info ignored
· Improvement : In Save Results and Export Tool, lets add some statement separators support
· Improvement: AQExcelSpreadsheet: add methods to manipulate sheet names
· Bug: On a stacked pivot chart the Y axis is still too large for the max stack height
· Bug : Trendchart - setShowRowTrendChart - a large number appears over
· Informix extract trigger sql and code fix to handle large trigger body code.
· AQProjectFile.read() removes BOM
· Library Update : JIDE 2.11.4-aquafold build : Fix for Pivot Grid in use of AQReport API.
September 27th, 2011New Features:
· Secure Shell (SSH) Environment
· Perforce Version Control Support
· Git Version Control Support
· New Database Version Support
· Autosave Workspace
· Shortcut Toolbar Enhancements
· Multithreaded UI
· Integrated Compression Tool
· Integrated PDF Viewer
· Import and Export Tool
· File Browser
· Schema Browser
· Table Data Editor
· Query Completion Sound
· Editor Matching Braces Color
· Query Window
· Support for remembering last parameterized varibale value per execution in the Query Window
· Save Results to Excel, View in Excel, View as Spreadsheet
· Query Window Grid Results
· Schema Compare Results
· Text Results Options
· Script Object to Window CREATE (FULL)
· Key binding to "New Frame Window" - Ctrl-Alt-N
· Hide Application Tree Tabs - Servers, Files and Projects Tab
· New option - Case for auto-completion
· New option in File Browser to quickly mount home and desktop folders
Enhancements:
· OS File MIME Types Integration
· Grid, Pivot Grid & Charts
· Quick Excel & Excel 2007 Support
· ER Model Enhancements
· Open API Enhancements
August 4th, 2011· FIX: Visual Editing: Alter a view from Oracle -> Tables -> Dependencies -> View, is not setting the schema correctly.
· FIX: Visual Editing: MySQL : Alter Table on table with an "int" datatype. Change to Unsigned = YES and rename. DDL doesn't generate UNSIGNED syntax
· FIX: Visual Editing: Oracle : Alter Table on table, default value for parallel when creating table will not script a value.
· FIX: Visual Editing: Alter Table on PostgreSQL with VARCHAR(0) prevents modification
· FIX: Table Data Editor: will not save data if you close the window and choose to save ... if PK is not defined.
· FIX: ER Modeler: PostgreSQL : Varchar does not require length anymore
· FIX: ER Modeler: Relationship positioning isn't always saved
· FIX: Subversion: Locking issues with refresh workspace would cause refresh to occur more often.
· FIX: Open API: Added compare options to AQSchemaComparator
· FIX: Open API: Fix for DB2 compare of procedures. The parameters for arraylist where not sorted on extraction.
· FIX: Open API: Oracle Schema Compare saveToHtml would overwrite Package with PackageBody
· FIX: Open API: Added API : AQDataSet[] AQStatementResult.getResultList()
· FIX: Open API: Added API : AQExcelSpreadsheet
· FIX: Open API: Open API CoreResultSet.getRow() was not making special conversions for datetimes
· FIX : Query Window : Added unicode support for the rich text clipboard transferable.
· FIX : Query Window : Queries of length 14,000+ chars would prevent execution.
· FIX : AquaProjects : Allow context menu to "Debug in Procedure Debugger" in Projects
· FEATURE : Add icon with tooltip to each Grid Results where the tooltip is the first 100 chars of the SQL for the results
May 2nd, 2011· FIX: MySQL : View Extraction was quering on all databases
· FIX: PostgreSQL 8.3+ : Extraction and scripting of extra index options (USING, NULLS, FILLFACTOR, FASTUPDATE, TABLESPACE)
· FIX: Oracle : Scripting comments on views was use COMMENT ON VIEW, but should be COMMENT ON TABLE
· FIX: JDBC Driver loading order now puts Informix before DB2 to prevent obscure messages on Informix connection failure
· FIX: AquaProjects : Drag and Drop from AquaProjects now matches same as Server Tab.
February 14th, 2011· FIX: MS SQL Server : Object Search : Procedure source didn't search function source code.
· FIX: MS SQL Server : Procedure Editor : Executing a function with a timestamp or datetime parameter failed.
· FIX: MS SQL Server 7.0 : Scripting constraints included syntax valid only for SQL Server 2000 and above.
· FIX: PostgreSQL : Procedure Editor : Executing function with a MONEY datatype parameter would fail.
· FEATURE: Server Registration->Advanced : Added option "Always display column name in results" ... instead of column label.
November 18th, 2010· FIX: Server Registration : ODBC Datasource browser for 64bit now lists 64bit sources.
· FIX: ER Modeler : Database Compare didn't have all the options that the Schema Compare had
· FIX: Save Results to Delimited Text would wrap http:// values with tag
· FIX: Oracle : Table Data Editor : If a compound key contains data type of RAW, then UPDATEs and DELETEs would not take effect
· FIX: Apache Derby : Fix on handling boolean to support version 10.6.x
· FIX: SQL Server : Added option for NOCHECK in DDL
· FIX: Sybase ASE : Script CREATE TABLE on default segment now quotes default since it is a keyword.
· FIX: Typo in Open API AQSqlFormatter.setUseTabIdent method
· ENHANCEMENT: Added Open API aqua.system.getProperty(), aqua.request.getRemoteHost() and aqua.request.getRemoteAddr()
October 28th, 2010· FIX: ER Modeler : When comparing Model to Database never use Database name in fully qualified name, otherwise all objects are different.
· FIX: Table Data Editor openning from Schema browser doesn't have limit to 1000
· FIX: DB2 LUW : Differentiated between ASC/DESC columns in an index & INCLUDED columns in the extraction.
· FIX: Apache Derby : Version 10.6+ queries comparing boolean columns can no longer use 0/1, must use 't' or 'f' now
· FIX: Query Window : CTRL-ENTER will auto-complete popup is up would not execute current statement.
· ENHANCEMENT: Enabled access to Swing/AWT in Open API.
October 28th, 2010· ENHANCEMENT: Added option File->Option->Results->Grid Results->[Persist sort across execution]
October 8th, 2010· FIX: Procedure Editor : Execution of procedure remembers parameter values of previous execution.
· FIX: nCluster : datatypes returning null type now made to varchar to minimize issues.
· FIX: I18N : Object Permission Dialog did not work on non-English interface because of I18N bug.
· FIX: Aqua Commands : parameter parser did not work in certain scenarios
· FIX: RunScript.sh/.bat : would not exist after execution of script.
October 5th, 2010· FIX: Charts : Changed the method or repainting charts on AWT window. Paints smoother and prevents crash on unreliable Windows video drivers.
October 1st, 2010· ADStudio breaks new ground for Relational Database tools with the introduction of the Aqua Open APIs, a JavaScript based language called AquaScript and a full-fledged Integrated Development Environment (IDE). Users will now have API access to nearly all of ADStudio's built-in functionality and be able to create fully automated end-to-end solutions.
· Open APIs enable developers to write scripts that access the functionality of ADStudio to create custom solutions and tasks that fall outside of the product's GUI restrictions. This includes current functionality around database access, database schema DDL generation, compare tools, version control, data pivoting, charts and much more. We have also introduced new functionality, including random data generation, statistical functions, local file system and Hadoop file system.
· New Database Support: Netezza
· Charting Enhancements
· ER Model Enhancements
· Table & Index Partitioning Enhancements
· Even more Enhancements
September 21st, 2010· FIX: Merged 8.0.26 fixes
· FIX: ER Modeler : Now auto-generates names for new objects
· FIX: ER Modeler : You can now copy/paste regions and notes across models regardless of database type.
· FEATURE: Netezza : Native support for Netezza.
September 9th, 2010· FIX: Merged 8.0.25 fixes
· FIX: MS SQL Server : Schema Tree View : Disabled Triggers now have icon to indicate status
· FIX: Windows Chart Software Renderer : Handle to Windows Device context was not released when closing ADS. Launching and closing ADS about 1000 times would cause ADS GUI refresh issues. [Restart Windows]
· FIX: Pie Chart : Pie Chart label location calculation is much better now.
August 20th, 2010· FIX: Merged 8.0.24 fixes
· FIX: Drag & Drop of servers from Projects to Servers didn't work.
· FIX: Open API : Lowercased method .isTeraData() to .isTeradata() in AQMetaData
· FIX: Open API : AQUtil.htmlEncode() did not convert all characters correctly
· FEATURE: Open API : Added method .isNetezza() to AQMetaData
August 11th, 2010· FIX: Updated geo.jar for enhanced world map resolution.
· FIX: Save Results Dialog on OSX had button sizing issues.
· FIX: Sybase ASE 12.0 and below : Query Window : Change Database would fail because of [] quote identifier in DDL
· FIX: Open API : aqua.random.nextColor() now matches : http://en.wikipedia.org/wiki/List_of_colors
· ENHANCEMENT : Open API : Added method .getComment() to aqua.vcs -> AQRevision
· ENHANCEMENT : FEATURE: Server Registration Dialog -> Driver tab enhancements
· OPTION : Added File->Options->ER Modeler:[Enable Mouse Wheel Zoom] - [Invert Mouse Wheel]
August 7th, 2010· FIX: Query Window : If you query and sort grid results, then query a different result without the sorted column would cause grid result not to show for that query.
· FIX: AquaScript Editor : On Linux a Shift-F1 on a function woult open browser to JavaDoc incorrectly because of space in URL.
· FEATURE: AquaScript Editor : Lines with syntax error now give description of what the syntax error is.
· FEATURE: Server Registration Dialog : Added "Driver" tab to give more information on URL and driver parameters.
August 4th, 2010· FIX: Sybase IQ : Added support for "IQ UNIQUE" clause in table DDL
· FIX: Sybase IQ : DBSPACE extraction was using deprecated system catalog table
· FIX: Oracle : Fix for DDL generation on table, CHAR used on columns of type varchar2, char, nchar, nvarchar2 datatypes
· FIX: Informix : ER Model convertion on varchar(100,1) would convert to varchar(0)
July 23rd, 2010· FIX: Sybase Debugger : Second debug session would have connection disconnect.
· FIX: Server Registration: choosing SQL Server Single Sign On and then Sybase, doesn't re-enable the username/password
· FIX: Grid Results : Aggregate bar broken if SUM is not chosen
· FEATURE : Debugger : Parameter dialog now has menus to set NULL or DEFAULT to all parameters or selected
· UPDATE : Updated jConnect JDBC Driver
July 6th, 2010· FIX : MS SQL Server : Debugger would not allow a Step Into a User Defined Function.
· FEATURE : MS SQL Server : Script Login now scripts password encoded
· FEATURE : MS SQL Server : Script Login now includes Script CREATE (Full) to include database users associated to Login
· FEATURE : MS SQL Server : Script Job now inlcludes full Job information such as steps.
· FEATURE : Sybase ASE : Script Login now includes Script CREATE (Full) to include database users associated to Login
· CHANGE : Query Builder : Execute Edit now uses the Max Results from the Query Builder
June 16th, 2010· FIX: SQL Server 2008 : Extract Index with WHERE clause was not supported.
June 16th, 2010· FIX: SQL Server : View in Excel, doesn't show values for Bit columns.
June 1st, 2010· FEATURE: Memory Monitor Dialog which is accessible by single click on botton right memory status indicator.
· PERFORMANCE: Informix storage information for Tables issues query that is now more optimized.
· FIX: DB2 LUW 8.1 and below : Schema Browser, procedure list would show empty list because one missing column in query.
May 26th, 2010· FIX: Server Registration : ODBC datasource browser now includes User DSN from Windows Registry
· FIX: nCluster : Script table which inherits from other table will not script inherited columns for table.
· FEATURE: Grid Results : Added "View in Browser" to menu item
· FEATURE: SQL Debugger for Sybase ASE : added support for Sybase ASE 15.5
· OPTION: Added option to datastudio.properties "editor.keybindings.completionShowAction" to allow to change keybinding for autocompletion
May 12th, 2010· FIX: Sybase IQ : Time / Date columns would return "[Err]" because IQ doesn't return the column type name in the resultset for Time and Data columns.
· FIX: DB2 LUW : Added extracting and scripting of pctfree # table information as ALTER TABLE
· FIX: Sybase ASE : DDL Generation : Create table ddl where column has multi rows in catalog table but is not computed would make datatype length "null). Seems to happen on databases dumped in Sybase ASE 12.5 and imported to 15.0
· FIX: DB2 iSeries : ER Modeler : Generate Script would always fully qualify Primary Key in DDL
· FIX: ER Modeler : ER Modeler : Relationship route is not saved in some cases
· FIX: Export Tool : Oracle 9i and above now supports "WITH CLAUSE" in the export data "SELECT" statement option
· PERFORMANCE: Table Data Editor : Performance problem when setting NULL on large resultsets. Aggregate bar would calculate with every cell change.
· OPTION: Sybase ASE : inverted default sybase quote_identifier option
· FEATURE: Oracle : Package Editor : Added support for .pck / single file opening and saving.
· FEATURE: Query Windows : When you reconnect, it now refreshes the list of databases and schemas
· FEATURE: Schema Browser : tree will now show users that belong to a role under db2 9.5 and above.
· FEATURE: Schema Compare : Schema compare now has option to include indexes/triggers on table comparisons.
April 10th, 2010· FIX: Oracle : Added support for SYSASM role in Connect As
· FIX: DB2 iSeries : ER Modeler Table editor didn't support extend column properties, including identity column info.
· FIX: Sybase ASE : Object Search tool had a join condition missing in query for procedure body searches, which made search slow.
· FIX: Sorting in Grids for String now uses Collator instead of Comparator
· UPDATE: Installers now have Java 1.6.0_18 bundled, instead of Java 1.6.0_16. This is to resolve Windows 7 GUI issues.
March 29th, 2010· FIX: Visual Editing was using option of [";" statement separator] which would cause procedure editing to fail.
· FIX: Allow .variable TIME/TIMEZONE format to specify fractions with up to nanosecond precision
· FIX: Quick Filter : Column filter popup would not scroll it the list was too big.
· FEATURE: Sybase ASE -> Added support for Execute Callable Statements for procedure with EXECUTE BIND
· OPTIMIZATION : Oracle : Extracting DBMSOUTPUT is now handled on server with anonymous PL/SQL block to increase extraction speed for large results.
February 2nd, 2010· FIX: Oracle : Query for columns of LOCAL TIMEZONE would return error for data.
· FIX: Sybase ASE : Minor fix to extraction of database groups. If a database was dumped and restored, the query would not show all groups.
· FIX: Sybase ASE : New jConnect driver no longer allows connection when password expired. Added change password functionality to Server Registration dialog on button right to password field.
· FIX: MySQL : Script Table CREATE (Full) would script Unique Indexes that were system generated to support Unique Constraints.
January 23rd, 2010· FIX: (Sybase ASE 15) : View Database : Space Usage was merging Data and Unused together for Data size, and leaving Unused as zero.
· FIX: (Informix 7.3) : Object search for procedure bodies would fail.
· FIX: (MySQL) Table Data Editor didn't allow modification of TIMESTAMP column.
· FIX: Query Analyzer Window : Incremental Find hot key didn't work.
January 7th, 2010· FIX: (MySQL )Auto Describe not working
· FIX: (SQL Server 2005+) Table Data Editor : Was unable to INSERT a XML value.
· FIX: (Sybase ASE) : Script CREATE on tables with computed columns that are very long would create a multi-line computed column and cause the column name to display as multiple columns of same name.
· UPDATE: (Sybase ASE) Updated jconnect6.jar JDBC driver to latest EBF patch.
December 17th, 2009· FIX: Schema compare for functions and procedures needs to be compared based on parameter prototypes list, only when the database supports parameter overloading for the object of Function or Procedure. Otherwise procedures show up as different objects.
· FIX: Query Window - with MultiTab/SplitPane results - Openning windows, the odd numbered window open would focus on incorrect tab.
December 9th, 2009· FIX: PostgreSQL : Script Foreign Key constraint, under rare circumstances, order of columns for the foreign key constraint did not match.
· FIX: Sybase ASE - Visual DROP of Login. If drop of login fails, ADS would report as successful. This is because of how Sybase ASE driver handles execution of stored procedures.
November 14th, 2009· FIX: Sybase ASE : Scripting constraint would include database everytime for referencing table. Now only when it is in another database.
· FIX: Informix : Added syntax coloring on keywords : RETURNING, ELIF, RESUME, DEBUG, FILE, REPLACE.
· FIX: File->Options->Compare: compare option prompt label said "left", when it should have been "right".
November 10th, 2009· FIX: Oracle : Table CREATE Scripting now supports VARCHAR2(255 CHAR) format
· FIX: PostgreSQL 8.3 and above: Added UUID datatype support.
· FIX: DB2 Explain Plan : Column Names and Partition Columns values were displayed as Java Class names of the object.
· FIX: Schema Script Generator : Disable option "Generate full script for tables (indexes etc)" if user chooses Trigger or Indexes individually
· FEATURE: SQL Archive table now has sorting enabled.
· FEATURE: DB2 9.5 and above : Now has suppprt for Roles in Schema Browser, Scripting, Visual Editing, Server Script Generator, Object Permissions and Security Manager.
November 3rd, 2009· FIX: Informix 7.3 - Schema browser - Procedures were not listed.
· FIX: Oracle - TIMESTAMP TIMEZONE / LOCAL TIMEZONE columns are now retreived as strings so to include the timezone information.
· FIX: Disabling Auto Popup for autocompletion did not work for Windows 32bit. (Worked for Windows 64bit, Linux and OSX).
· FIX: Oracle - query results with timestamp subtractions would result in [err] results for column data.
· Oracle drivers return INTERVALDS datatype.
· FIX: SQL Archive : Delete Selected in SQL Archive would only delete one.
· FIX: SQL History : window opens outside of the visible screen area if previous instance saved it that way. (Dual monitor switching)
October 24th, 2009· FIX: Grid Results Charts - If a function series was added and a "Merge Series Axes" option was chosen, then the chart would not refresh until the OK button was clicked.
· FIX: Sybase IQ/Anywhere : When grouping by schema in Sybase IQ & Anywhere, we show schemas to be Users & Groups now. Reason: Groups can be an object owner.
· FIX: Sybase IQ/Anywhere : Database schema nodes didn't refresh if new schema created. Required disconnect/reconnect.
October 16th, 2009· FIX: Autocompletion now handles Sybase Index Hints
· FIX: TAB key does not move cursor to adjacent cell in the Table Data Editor
· FIX: Quick filter was filtering numberic values as formatter values "commas" (eg 1,200,345)
· FIX: Teradata connection type didn't allow for "Driver Params" in Server Registration->Advanced becaused it used "?" instead of "/" and "," as parameter separators in driver URL.
October 14th, 2009· FIX: Sybase ASE : Database Device DDL scripting didn't include the dsync option.
· FIX: Sybase ASE 12.0 doesn't support @@unicharsize, so now using @@ncharsize
· FIX: SQL Server : Job History dialog would not display history because of GUI refresh issue.
· FIX: SQL Server : Minor GUI fixes in Restore Database dialog.
· FIX: Reexecution of query with multiple sorted Pivot Tables, would not persist sorting on pivot table.
· FEATURE: Server Registration : Oracle OCI, Sybase INI and ODBC browse dialog now have quick filter.
October 6th, 2009· FEATURE : ER Modeler : Find Dialog : Now includes indexes, columns, constraints and references.
· FEATURE : Procedure/Package Editor now use Tab Title Format just like Query Window.
· FEATURE : Added "Clear Document" action to Text Results and Message Results editor popup menu.
· LOCALIZATION : Completed localization of new prompts for Japanese (all 21 languages complete).
September 23rd, 2009· FIX: Added File->Options->Registration Defaults for nCluster, DB2 z/OS and Teradata
· FIX: nCluster : Performance problem with nCluster indexes extraction.
· LOCALIZATION : Completed localization of new prompts to all languages except Japanese.
September 22nd, 2009· FIX: Scripting DB2 LUW Create Table with Identity/seed/increment by no cache from ER Model would fail.
· FIX: nCluster: Fixed nCluster data types in ER modeler.
· FIX: nCluster: Added Views selection option to Query Builder for nCluster.
· FEATURE: ER Model : Copy will copy image to OS clipboard for pasting into Office and Email clients.
September 16th, 2009· FIX: Update from JIDE library 2.7.2 to 2.8.0 to fix minor UI bugs.
· FIX: Oracle : Script Table Full with Default Parallel would not script NOPARALLEL clause.
· FIX: DB2 XML Datatypes values where not extracted as XML text, but as java class names.
· FIX: ER Modeler conversion : informix->mysql conversion sets auto_increment option
· FIX: ER Modeler -> Generate Script ... need to add option "Tables: Use conditional drop"
· FIX: Online Documentation was linking to ADS 7.5 ... now linking to 8.0
· FIX: Options dialog still defaults to 'General' regardless of last choice
· FIX: Results Compare: Dialog for choosing results, now focus traversal with tab, shift-tab
· FIX: Added support for Global Temporary tables in DDL Generation, Visual Editing and ER Modeler
· FIX: Teradata : Script comments for tables and columns
· FEATURE: Visual edit now supports create/alter database for Teradata.
· OPTIMIZATION: (ER Modeler) Now able to open large 2000+ tables and 2000+ relationship models.
· Also, added Window->Faster Rendering option. This renders dotted relationship lines as gray lines. (dotted are very slow because of Java 2D)
August 31st, 2009· FIX: Table Data Editor : Now has the ability to defined unclonable columns for datatypes that are automatically generated by database.
· Added SybaseASE-timestamp and Informix-Serial.
August 18th, 2009· FIX: Sybase ASE : Script Temporary Databases didn't include the TEMPORARY clause.
August 15th, 2009· FIX: Schema Compare : Indexes are now sorted by name so that the compare is a logical compare even if they were ordered incorrectly
· FIX: ER Modeler->Generate Script on DB2 LUW : Scripting Table with Identity ALWAYS would cause exception.
August 11th, 2009· FIX: Sybase IQ : (12.6 and above) : Scripting Procedure. Some IQ installations (primarily upgraded installations) sometimes have zero length or padded blank values for sysprocedures.source which causes ADS to script a blank CREATE PROCEDURE block.
August 5th, 2009· FIX: Sybase IQ : (12.6 and above) Scripting Procedure would script compiled/unformatted create procedure code. Now scripts original code from system catalog sysprocedures.source.
· FIX: SQL Formatter would not handle CASE correctly under certain scenarios and would break SQL
· FIX: Disabled DriverManager.setLoginTimeout() because some JDBC drivers use this as a socket timeout. (Which is stupid, but we can't do anything about that) The DriverManager.setLoginTimeout() was initially set to prevent ADS from pausing for a long on a connection attempt that failed.
July 29th, 2009· FIX: Oracle : Query on Oracle Struct objects now converted to strings, such as RDF data.
· FIX: DB2 iSeries : DriverMangaer.loginTimeout() is global. Set to 0 (zero) when attempting to connect to iSeries because of JTOpen bug
July 23rd, 2009· FIX: DB2 iSeries : New JTOpen JDBC driver for DB2 iSeries has bug that uses DriverMangaer.loginTimeout() as a connection timeout. Workaround, ADS doesn't set LoginTimeout for DB2 iSeries.
· FIX: DB2 Visual Explain would not work if user would change current schema to different then user login name
· FIX: DB2 Visual Explain ... if explain tables don't exist on user schema, fall back on SYSTOOLS schema
· FIX: DB2 Alter Tablespace was not extracting datafile size
July 22nd, 2009· FIX: Schema Compare : Small memory leak fix
· FIX: Table Data Editor: on Mac OSX selects first typed character
· FIX: Table Data Editor: A cloned row of a cloned row would not retain data formats.
July 14th, 2009· FIX: Sybase ASE : Extract Table Check Constraint : Check constraint longer then 255 characters was truncated to 255.
· FIX: Localization Mnemonics : Now avoids duplicate mnemonics in dialogs.
July 11th, 2009· MINOR CHANGE: OSX - Lowered acceleration on mouse scroll wheel for navigating editors.
July 7th, 2009· FIX: Schema Compare: Now sorts triggers by name in DDL generation to have closer and more acurate matches in the DDL text compare, subject to mis aligned triggers because of order.
· FIX: DB2 iSeries : Execute Edit, case sensitive for table names was not working.
· FIX: Import Tool : MySQL : Create Table from import tool would have initial values of "PREVIOUS" for datadir and indexdir which would prevent creating table.
· FIX: Document Tab Pane : Having multiple windows open in multiple Vertical Tabs, and then clicking on a tab in one group would also select appropriate tab in other groups.
July 1st, 2009· FIX: MySQL : Script CREATE PROCEDURE & FUNCTION now includes in DDL : NOT DETERMINISTIC, CONTAINS SQL, READS SQL DATA, NO SQL, MODIFIES SQL DATA
· FIX: DB2 iSeries : Execute Edit was always case sensitive on table names requiring upper case all the time.
· FIX: OSX : Default key bindings for bookmarks on OSX didn't work, so changed to CTRL-Command-[M/Up/Down]
July 1st, 2009· FIX: Sybase ASE : Script Index truncated columns after 15 columns.
· FIX: Bookmarks on Package/Procedure editors didn't work with the popup menus.
July 1st, 2009· FIX: Oracle : Executing or Debugging Functions/Procedures which had a return type of TYPE AS TABLE would fail.
June 17th, 2009· PATCH: OSX 10.5 Java 6 Update 4 has a bug which prevents ADS from launching.
· This ADS patch only includes patches to the JIDE libraries to work around the bug introduced by OSX 10.5 Java 6 Update 4.
· The JIDE patches dynamically determine the Java version to determine how to work around the bug.
To apply and fix the bug you need to do the two following things:
· Update your ADS installation with this patch.
· On OSX copy you /System/Library/Frameworks/JavaVM.framework/Versions/A/Resources/MacOS/JavaApplicationStub to ... /Aqua Data Studio.app/Contents/MacOS/JavaApplicationStub
· NOTE: This build does not have any changes to ADS.
June 11th, 2009· FEATURE: File->Options->Results->Save Results->[Maximum string length saved for Excel worksheet].
May 14th, 2009· FIX: DB2 iSeries : connections with Driver Param need to create URL with ";" instead of ":"
· FIX: Sybase ASE Storage Manager : Removed "Space Available" column from database tab as value was always "Unavailable".
· FIX: Oracle Session Manager: Explain Plan on Current statement would not work if no schema was indicated and create/drop option was disabled.
· FIX: Explain Diagram: Contained minor memory leak.
· FIX: Import/Export Tool: Minor layout of GUI on OSX.
May 14th, 2009· FIX: Informix Table extraction queries have been optimized. Informix database with 54,000 tables in system catalogs would extract a single table in 10 minutes.
· FIX: Editor : Replace functionality would replace twice sometimes is multiple windows of the same editor type were open.
May 14th, 2009· FIX: Informix Indexes extraction queries had a missing JOIN criteria which would produce a very slow query taking minutes in certain databases.
May 10th, 2009· FIX: Applied Text Results optimization fix to Text History Results.
· FIX: Informix: Index Extraction: Optimized extraction query for performance, which was possibly slowing down Table->Script->CREATE
· FIX: Results Compare progress bar was broken so it didn't allow you to cancel comparision.
· FEATURE: Query Window: Added CTRL-SHIFT-; hot key to enable/disable [";" as statement separator].
May 10th, 2009FIX: Text Results: Speed Optimizations. The new editor component introduced performance issues in Text Results for ADS 7.0. We have fixed the issues and increased performance even over ADS 6.5. Relative tests on a 100,000 rows SELECT for Text Results :
· ADS 6.5 == 18 seconds
· ADS 7.0 == 1 minute 3 seconds
· ADS 7.5 == 13 seconds
· FIX: Query Builder: Default keybinding for Copy SQL is now Ctrl-Shift-C ... as Ctrl-C doesn't map since it is consumed by all other components.
· FIX: Query Builder: Mouse Click Menu on tables->Unselect all columns would not work.
· FIX: Query Builder: Loading new query build file on a different connection would not refresh database list in Add Table Dialog.
· FIX: Query Builder: Saving to file with column expression and alias combination would fail.
· FIX: Query Builder: On OSX, clicking on Table Entity Pane background would print harmless exception. Bug in OSX Java. Found workaround.
May 10th, 2009· FIX: Table Data Editor: Syntax coloring bug fix for sequential operation of clone, delete, clone, change primary key.
· FIX: Export Tool: If SELECT statement had comments, they would be removed before execution.
· FEATURE: Query Builder: Added support for BETWEEN operator in Quick Criteria Mode.
May 6th, 2009· FIX: Oracle: Package Editor would fail to open, now fixed.
· FIX: ER Modeler: Russian translation fix for dialog closing window.
· FIX: Informix w/ Replication: Possible performance issue to Script->CREATE on tables in databases with replication.
May 6th, 2009· Internal Build.
May 5th, 2009· FIX: Results Compare would fail on NULL comparison values
· FIX: Editor Abbreviations from previous versions of ADS would not transfer over to 7.5 and would require recreation if there were more then one.
May 4th, 2009· CRITICAL FIX: SQL Server BIGINT datatypes: Large Numeric Values (greater then 16 million) would lose precision in data extraction. Values were converted from Long to Float and back to BigDecimal, which could loose precision.
· FIX: ER Modeler/Visual Editing : Added support for length on binary/varbinary datatypes for SQL Server, Sybase ASE, Sybase Anywhere and Sybase IQ
· FIX: Query Builder: When unchecking a row in graph entity, only remove the changed row.
· This bug is new in the 7.5 branch, and did not exist in version 7.0 or previous versions.
· The bug was introduced in the 7.5 code branch as part of the memory optimizations included in 7.5. For SQL Server BIGINT datatypes, ADS stores them are BigDecimal values, but the JDBC drivers return them as Long values. The bug would convert the Long values to Float and then back to BigDecimal values which would potentially loose precision values depending on the actual value. This would effect any data extraction on SQL Server with BIGINT datatypes. If you have any questions on how this may affect your systems please contact us at (architect@aquafold.com).
May 4th, 2009· FIX: Editor: Option to enable anti-aliasing was not working.
· FIX: Editor: Abbreviation expansion would place cursor at beginning of the expanded on first row only.
· FIX: ER Modeler: Sybase numerics labels didn't include precision and scale. ER (precision,scale)
· FIX: Update to jInterop library to fix SQL Server Debugger Bug. Debugger for longer then 6 minutes at one time would sometimes disconnect debugging session.
· FIX: Results Diff: Preview didn't expect nulls, and memory problem.
· FEATURE: Double click on Execution Plan Grid and Properties Grid in Explain Diagram now displays in Text Dialog.
· FEATURE: Local Permissions now use a dynamic tempdb name for SybaseASE as the tempdb is dynamic for logins.
· FEATURE: Added "';' Statement separator" option to File->Options->Scripts for each database to allow enabling on a per database basis.
April 27th, 2009· Memory Optimizations - Reduced Memory Footprint – now, Aqua Data Studio uses less memory(30% to 40% less) than previous versions at startup and when retrieving results of more than 65,000 rows.
· New & Enhanced Editors - New Java and JavaScript Editors – edit JavaScript and Java with syntax highlighting and all of the other features you get from Aqua Data Studio's HTML, SQL, XML and text editors.
· Enhanced clipboard, Bookmarks, Find and Replace allow you to copy source code and keep its syntax highlighting, navigate through documents with user-defined bookmarks, as well as find and replace with escape characters.
· New & Enhanced Charts - New charting tools have been added to include more features developers and analysts need. You now have more control when manipulating the visualization of data including Clustered Column Charts, Stacked Column Charts, Clustered Bar Charts, Stacked Bar Charts and Stacked Line Charts. Columns in a column chart can now be swapped out with different basic shapes like cones and pyramids. Just like ADS 7.0, all options are scriptable and include support for pivot charts.
· Subversion 1.5 Support - Subversion (SVN) 1.5 support is built into Aqua Data Studio 7.5, and ready for use with your preexisting Subversion 1.5 installations. We've even included a Relocate feature.
· File Search Tool - We’ve added a powerful new File Search Tool into Aqua Data Studio 7.5 for use with your scripts directory and version control repositories. Use it to find, sort and filter files by their content, filename and more. You can include/exclude file types in your search and even search with regular expressions.
· Visual Editing Enhancements - Aqua Data Studio 7.5 expands Visual Editing support to allow the visual renaming of schema objects.
· ER Modeler Enhancements - The Entity-Relationship (ER) Modeler that is as powerful as even the best standalone database diagramming tools, now allows objects within an ER Model to be renamed. Relationship connectors can be rerouted within diagrams.
· DBA Tools Enhancements - The Storage Manager has been greatly enhanced for Oracle, DB2, Microsoft SQL Server, Sybase and MySQL for tuning and monitoring of database storage. ADS 7.5 has enhanced views for Database Size, Table Size and Index Size. Now, DBAs can quickly visually evaluate storage issues for database tuning and performance enhancement.
· The DBA Tools now allow you to save column positioning and width, keep filter settings between refreshes and quickly reconnect with the new reconnect button.
· More Features in ADS 7.5 for More Databases - Aqua Data Studio 7.5 includes other enhancements and improvements.
· Nine New Languages (21 Total) - Aqua Data Studio 7.5 now speaks 21 languages. If you read Chinese (Simplified), Chinese (Traditional), Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hindi, Japanese, Korean, Norwegian, Polish, Portuguese, Portuguese (Brazilian), Russian, Spanish or Swedish, it speaks your language.
April 23rd, 2009· FIX: (Oracle) Optimized Oracle queries for Table Extraction.
· FIX: (DB2 for LUW) GRANT and REVOKE Scripting was not working for Procedures and Functions.
· FIX: (SQL Server) Database Restore : running ADS on Linux would not allow UI to indicate restore file.
· FIX: (Sybase ASE) Visual Editor for Create Table had identity option enabled for all numeric fields except for "numeric".
· FIX: (Sybase ASE) ER Modeler: Support for Sybase ASE IDENTITY parameter.
· FIX: (OSX) Checkbox renderer was messed up in Option Dialog for OSX.
· FIX: Table Data Editor : Truncation warning on numbers with large scale values is now removed as the warning was not correct.
· FIX: Query Builder: Adding a table with "Auto Join" enabled will add a join for FK''s where the FK is to the same table.
· FIX: Query Builder: Opening query builder file saved in one language and opened in a different one would fail.
· FIX: ER Modeler: Indexed column order didn't match order is DDL.
· FIX: ER Modeler: Unique clustered constraint fix for DDL generation.
· FIX: Schema Script Generator: title reflects database/schema for clarify on minimized dialogs.
March 15th, 2009· FIX: Removed internationalization for ansi_nulls etc. in connection dialog.
· FIX: Query Analyzer: Executing a script with .setPivotResultSettings would not set saved Stacked Charts option.
· FIX: OSX: ER Printing on OSX, fixed few minor repaint bugs.
March 15th, 2009· FIX: Sybase ASE: Script Procedure EXECUTE to a procedure with "bit" parameters would generate default values of "false" instead of "0"
· FIX: Sybase ASE: Visual Create of Database Device would limit device number to 9 or below.
· FIX: OSX: ER Modeler would not print on certain printers from OSX.
March 15th, 2009· FIX: Sybase IQ: ADS now provides APPINFO information for EXE so that sessions provide the name of the application.
February 10th, 2009· FIX: Memory Consumption - CPU Peak bug. If a query with a huge memory usage is executed, the ADS will cancel query to quit, but would pause application for an extended time with a high CPU usage.
February 10th, 2009· OPTIMIZATIONS: Minor memory optimizations accross the application. Hope to better performance over long term use of the application.
February 10th, 2009· FIX: Automate Morph to Lower/Upper would be incorrect when there was a comment containing an unclosed single quote
· FIX: Sybase ASE: Table Data Editor: Enabled "sysname" datatype for editing.
· FIX: Oracle & DB2: Scripting DDL to new window would not set current context of schema based on browser.
February 10th, 2009· FIX: Sybase ASE 15 : Support for Computed Columns in Table Extraction/Scripting
· FIX: Custom Pivot Field Aggregate Functions didn't with Totals were enabled.
· FIX: Grid results toolbar repaint problem (with cell aggregator).
· FEATURE: DB2 iSeries: Added "Logical Files" folder to schema browser.
February 10th, 2009· FIX: Sybase IQ 12.5 - Schema Browser : Table constraints node used [] quote identifers for query which failed on 12.5
· FIX: Sybase IQ: Table Data Editor had datetime datatype columns disabled.
February 10th, 2009· OPTIMIZATION: Query Analyzer: Execution of queries ... calibrated performance and memory recovery. Seems that a 400ms memory recovery operation can take alot longer on older CPUs. Execution should be faster and more noticable on older machines.
February 10th, 2009· FIX: Sybase IQ 12.5 : Extract Index would fail because of [] quote identifier. Changed to ""
· FIX: Oracle : Object Search: Searching for column names would potentially return duplicates are JOIN query would only join on TABLE_NAME and not OWNER.
· FIX: Register Server: Configuration an Oracle connection for use with RAC would require a SID (although you could put space). No longer required.
· FIX: MS SQL Server : Objects named with Asian charactersets would fail to extract because '' literals used in extraction query instead of N''
· FIX: Context Menu key on keyboard didn't trigger popup menu.
· FIX: Table Data Editor: UPDATE or DELETE where the primary key was a Unique Index and one of the columns was Nullable, and the value of one was a NULL, ADS would make WHERE condition COLUMN=NULL instead of COLUMN IS NULL.
February 10th, 2009· FIX: Sybase ASE 11: Extract Index tried to get crdate of indexes, but column doesn't exist in Sybase ASE 11
· FIX: Sybase ASE 11: Script Database for ALTER and DATABASE would use KB number format. Sybase 11 only supports MB.
· FEATURE: Table Data Editor: Added feature to provide table level transaction settings in the datastudio.properties file with this option and format ...
· tabledataeditor.settingtableoverwrite=MyDatabase.dbo.MyTable,{FULL_TRANSACTION | BATCH_TRANSACTION | THRESHOLD_TRANSACTION},2 + YourDatabase.dbo.YourTable,{FULL_TRANSACTION | BATCH_TRANSACTION | THRESHOLD_TRANSACTION},3
February 10th, 2009· FIX: Sybase ASE 12.5 : Detail View and Storage View for tables in temp databases now exclude segment name and use isolation 0 for queries to reduce contention.
· ENHANCEMENT: Script Detail Results: Persist column widths in script details results.
February 10th, 2009· FIX: Generating Full Script of Charts where the chart was Stacked Area Chart would not save chart type.
· ENHANCEMENT: Script Detail Results: Added columns "Resultsets", "Rows Effected" and "Rows Updated".
February 10th, 2009· FIX: Auto-Describe now includes UNIQUE and CLUSTERED option in text description
· FIX: Sybase ASE : Alter Table Dialog: Adding and Dropping columns at the same time would cause incorrect SQL statement. Adding columns or dropping columns in any single operation would be ok.
· FIX: Table Data Editor: Would give a truncated data warning on paste when no truncation happend.
· FIX: EXECUTE BIND for Oracle, no longer sets NULL value for user defined datatypes
· FIX: Sybase ASE: Extracting procedures and functions in Sybase ASE on UTF-8 databases would add extra blank spaces.
· FIX: Support for Table and Column comments in DB2 iSeries
· FIX: Drag-n-Drop from cell of Grid results now uses displayed value instead of raw values for Numbers and Dates.
· FIX: DB2 Session Manager: Didn't display current SQL for 9.0 and 9.5.
· FIX: ER Modeler: Table Dialog: Delete key didn't DELETE row, now does.
· FIX: Sybase ASE: Script Procedure CREATE. Certain procedures with over 15,000 lines on Sybase 12.0 server would be out of order.
· FIX: Sybase ASE: Alter Database, recalculating size when changing size type was incorrect
· OPTIMIZATION: Optimize free memory reallocation when executing queries and closing query windows. Also optimized memory on SVN Update and Commits.
· FEATURE: Schema Script Generator: Added Inline Schema Script Comments option
· FEATURE: Query Analyzer Results: Script Details: Added Server Execution Time
· LOCALIZATION: Minor bug fixes
· LOCALIZATION: Japanese Translation. Original translation was not good enough according to Japanese users. Now includes a complete and new translation which is very accurate and usable by users.
LOCALIZATION Update:
· (Status: Review) : 100% : Spanish
· (Status: Review) : 100% : French
· (Status: Review) : 100% : Italian
· (Status: Review) : 100% : Portuguese (Portugal)
· (Status: Review) : 100% : Portuguese (Brazil)
· (Status: Review) : 100% : German
· (Status: Review) : 100% : Russian
· (Status: Review) : 100% : Korean
· (Status: Review) : 100% : Chinese (Traditional)
· (Status: Review) : 100% : Chinese (Simplified)
· (Status: Review) : 100% : Japanese
December 13th, 2008· FIX: Detail Views numbers are now formatted based on locale.
· FIX: SQL Server: Scripting binary datatype didn't include length.
· FIX: Sybase ASE: Export Date column would also put time.
· FIX: Sybase Any/IQ: Use "[" and "]" as quote identifiers for Sybase Any and IQ so they always work without set quoted identifiers.
· FEATURE: Table Data Editor: If no primary key, or unique constraint defined, TDE will look for a unique index to identify primary key columns.
December 10th, 2008· FIX: SQL Server Procedure Editor/Debugger would fail when procedure had a parameter with BIT datatype.
December 10th, 2008· FIX: Parameterized Scripts: Multiple /* */ comments in scripts would sometimes prevent parameterized script from running.
December 10th, 2008· FIX: Inline Diff in editor was using HEAD copy for diffing in SVN.
· FIX: Informix Scripting Table with storage with their is a fragment would include same table space multiple times.
December 2nd, 2008· FIX: ER Modeler: View DDL generated from extracted view would script incorrectly
· FIX: Generate ER Diagram Dialog: reverse selection button didn't extract correctly.
· FIX: Oracle Debugger would fail when debugging procedure with parameter of type STRING
· FIX: Query Window: Auto Describe would not display indexes and contraints in SQL Server and Sybase when user was not logged in as "dbo"
· FIX: Oracle Package Editor on Body tab, Find Incremental didn't work.
December 2nd, 2008· FIX: Removed C, K, G and M as keywords for syntax coloring.
· FIX: Automate Introduce Columns, Qualified Columns and Value Stubs didn't work with quoted tables.
· FIX: SQL Server: SQL Server Agent DBA Tool, Jobs Tab had labels for creating Login and not Jobs.
· FIX: Oracle Debugger : Debugging packages on OSX would not break on breakpoints when running with "run" command.
· FEATURE: Chart Options toolbar now has two buttons for Save Defaults & Reset Defaults.
November 28th, 2008· FIX: Sybase ASE 15: Schema Script Generator: Permissions for Functions were not scripted
· FIX: Focus on query window editor after changing database in query panel through a pop down menu with arrow key navigation.
· FIX: Sybase ASE: Scripting Table with Indexes, now scripts clustered indexes before other indexes.
· LOCALIZATION: Minor Updates
November 24th, 2008· FIX: Added number formatting for BigDecimal in Detail View
· FIX: Optimized Queries for Sybase Table and Index Detail Views.
· FIX: Show Changes in SVN History with filter enabled prevented show changes from working in some cases.
· LOCALIZATION: Minor Updates
November 19th, 2008· FIX: Fixed wrong percentage during schema comparison if only some of the object types were selected.
· FIX: re-execution of query, where there was a chart with two series and two different chart types, would not save chart types for both series accross reexecution.
· FEATURE: Detail Views: Added number formatting to Detail Views.
· FEATURE: Detail Views: Added popup menu for enhanced copy.
LOCALIZATION - Update:
· (Status: Review) : 99% : Spanish
· (Status: Review) : 99% : French
· (Status: Review) : 99% : Italian
· (Status: Review) : 99% : Portuguese (Portugal)
· (Status: Review) : 99% : Portuguese (Brazil)
· (Status: Review) : 99% : German
· (Status: Review) : 99% : Russian
· (Status: Review) : 99% : Korean
· (Status: Review) : 99% : Chinese (Traditional)
· (Status: Review) : 99% : Chinese (Simplified)
· (Status: Review) : 99% : Japanese - Complete review and rewrite in progress ...
November 14th, 2008· FIX: Saving properties when datastudio.properties was read-only would cause Storage Managers to not function.
· Fix: Right click mouse click on top left pane of Grid Results now also pops up menu.
· FIX: Sybase ASE: Detail View for Tables didn't display tables with size above 4gigs.
· FEATURE: Sybase ASE: Detail View for Indexes, added Created Date.
November 10th, 2008· FIX: Minor spelling changes to I18N prompts
· FIX: Sybase ASE - Server Registration - sybase.ini lookup, support for '(' and ')' tokens in grammer
· FEATURE: Sybase ASE: Detail View for Tables & Indexes: Added storage information.
November 3rd, 2008· FIX: Results Diff filter was displaying NULL values where no row should be.
· FIX: Server Registration: ODBC Datasource browser didn't work.
October 29th, 2008· FEATURE: Pasting into Table Data Editor text values that exceed datatype length, will now warn the user.
· FEATURE: Procedure Editor and Debuggers: Execution Parameter Dialog now has a "Load" and "Save" button to allow the user to Save and Load values for parameters.
· FEATURE: Sybase ASE: Explain Plan Statistics IO now has quick filter and aggregate calculator.
October 29th, 2008· FIX: SQL Server : View GUI for Procedures, Functions, Views, would display blank if the CREATE DDL started with multiple comments, where the multiple comments were separated by an empty line with spaces.
· FIX: SQL Server: SQL Debugger would fail to login if the SQL Server is not listening on port 1433.
· FIX: Alt- Mnemonics didn't work in dialogs.
· FIX: Ctrl-] hotkey now pulls down tab list popup menu, now also displays hot key in tooltip.
· FEATURE: Import Tool: Now supports empty last column values per row in the import file.
LOCALIZATION: Update:
· (Status: Review) Spanish: 99%.
· (Status: Review) French: 99%.
· (Status: Review) Portuguese: 99%.
· (Status: Review) Italian: 99%.
· (Status: Review) Portuguese (Brazil): 99%.
· (Status: Review) German: 99%.
· (Status: Review) Japanese: 99%.
· (Status: Translating) Russian: 29%.
· (Status: Translating) Korean: 37%.
· (Status: Translating) Chinese (Traditional): 50%.
· (Status: Translating) Chinese (Simplified): 50%.
October 23rd, 2008· FIX: SQL Server: SQL Debugger would fail to login if the registration used Windows Authentication or Single Sign On.
· FIX: SQL Server: Scripting DDL for Procedure that user didn't have access to would give NullPointer exception error, now provides better error.
· FEATURE: Sybase ASE: Explain Plan Statistics IO numbers are now formatted
October 18th, 2008· FIX: JIDE Library Update. Minor bug fix, which was not reproducable on.
· FIX: SVNKit Library Update. Bug fix to allow connections to SVN 1.5 Servers.
· FIX: Opening SQL file in script tree would not open a GenericSQLKit, just a plain text with no syntax coloring.
· FEATURE: Added 2 options in RunScript to define encoding of input and output encoding.
· FEATURE: Sybase ASE Statistics IO grid for explain plan when executing with Show Execution Plan.
· FEATURE: Tab Coloring enhancements.
· LOCALIZATION: Update.
· (Status: Review) Spanish: 99%.
· (Status: Review) French: 99%.
· (Status: Review) Portuguese: 99%.
· (Status: Review) Italian: 99%.
· (Status: Review) Portuguese (Brazil): 99%.
· (Status: Review) German: 99%.
· (Status: Review) Japanese: 99%.
· (Status: Translating) Russian: 5%.
· (Status: Translating) Korean: 17%.
· (Status: Translating) Chinese (Traditional): 1%.
· (Status: Translating) Chinese (Simplified): 22%.
October 14th, 2008· Change: Tagged as release.
June 19th, 2008· FIX: Sybase 12 and below, the Script DDL for procedures didn't work
· FIX: Execute Edit in Oracle, where the explicit schema of a table is indicated in lowercase, but the actuall schema is in uppercase, and the current schema is different, would cause the execute edit to fail.
June 10th, 2008· FIX: SQL Server 2005: Object Permissions for Database Roles were not visible in Object Properties
· FIX: Enabled Export Tool to support Generic JDBC/ODBC connections. [Doesn't always work depending on Driver quality]
· FIX: PostgreSQL single/double quote bug in old procedural language syntax.
· FIX: Sybase IQ/Any - Schema Browser wouldn't show one procedure if there were two, one in different schemas.
· FIX: Informix - Script Index CREATE would place index columns in incorrect order.
· FIX: Import Tool now supports importing numeric values in scientific notation (eg 1.1e03)
· FIX: OSX 10.5 Grid Performance Bug
· FIX: Memory check issue bug. Now more refined.
· FIX: Import Tool: Having a decimal delimiter other then "." would generate numbers incorrectly for SQL since in SQL numbers always use ".".
March 24th, 2008· FEATURE: In Query Window, have a database combo box database change with a click, reset focus to the editor
· FEATURE: SVN Support for SVN_ASP_DOT_NET_HACK
· FEATURE: Added "Open In..." popup menu in the script tree
· FIX: Table data editor fix - max length (length -1)
· FIX: Fix problem when DebuggeeThread finishes (e.g. due to script error) before Debugger is ready, which doesn't reset toolbar.
· FIX: Partial Fix for User Defined Data Types in Sybase ASE stored procedure exeuction
· FIX: Fixed proc debugger user defined types support
· FIX: Fixed postgres trigger scripting.
· FIX: Fixed procedure debugger null parameters, which wouldn't script the parameter for execution
· FIX: Fix for Sybase ASE column scripting when changing datatype in visual editing ... must include NULL or NOT NULL
· FIX: Fixed columns for session manager
March 24th, 2008· FEATURE: In Query Window, have a database combo box database change with a click, reset focus to the editor
· FEATURE: SVN Support for SVN_ASP_DOT_NET_HACK
· FEATURE: Added "Open In..." popup menu in the script tree
· FIX: Table data editor fix - max length (length -1)
· FIX: Fix problem when DebuggeeThread finishes (e.g. due to script error) before Debugger is ready, which doesn't reset toolbar.
· FIX: Partial Fix for User Defined Data Types in Sybase ASE stored procedure exeuction
· FIX: Fixed proc debugger user defined types support
· FIX: Fixed postgres trigger scripting.
· FIX: Fixed procedure debugger null parameters, which wouldn't script the parameter for execution
· FIX: Fix for Sybase ASE column scripting when changing datatype in visual editing ... must include NULL or NOT NULL
· FIX: Fixed columns for session manager
February 1st, 2008· FIX: Table Data Editor: max field length is not checked when modified with dialog.
· FIX: (Oracle) Server Registration: Advanced Tab: Added "Use DBA_ views" as an option.
· FIX: (Sybase ASE) Scripting DDL for Caches didn't script object bindings.
· FIX: (SQL Server) Added support for Computed Columns for DDL CREATE of Tables.
· FIX: (SQL SErver) Schema Compare on SQL Server without password saved and Windows authentication doesn't work.
· FIX: (Sybase) Security Manager: Combo box with databases is not sorted.
· FIX: (Sybase) script proxy table is not correct.
November 27th, 2007· FIX: (Oracle 9i) SQL Debugger when debugging on 9i on Linux would not allow breakpoints.
· FIX: (Informix) Script CREATE User would not include statement separator.
· FIX: Results Compare copy to clipboard only copied one value on modified values when option File->Option->Results->Grid Results->Clipboard Copy as default format was enabled.
· FIX: Results Compare copy to clipboard would copy incorrectly when filtering.
· FIX: TreeTable sections of DBA Tools now allow you to select all rows and copy to clipboard.
· FIX: (DB2) Script Generator sort dependecy didn't take into account view dependecies on functions.
· OPTION: File->Options->General->General:'/' at End of Line Terminates Statement.
Find us on Google+
