7.0.37
- 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.
7.0.36
- 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.
7.0.35
- 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.
7.0.34
- FIX: Sybase IQ: ADS now provides APPINFO information for EXE so that sessions provide the name of the application.
7.0.33
- 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.
7.0.32
- OPTIMIZATIONS: Minor memory optimizations accross the application. Hope to better performance over long term use of the application.
7.0.31
- 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.
7.0.30
- 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.
7.0.29
- 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.
7.0.28
- 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.
7.0.27
- 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 '<STRING>' literals used in extraction query instead of N'<STRING>'
- 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.
7.0.26
- 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
7.0.25
- 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.
7.0.24
- 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"
7.0.23
- 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
7.0.22
- 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.
7.0.21
- FIX: SQL Server Job History: job history columns shifting in GUI fixed.
- FIX: DB2 iSeries, now uses SYSIBM.SCHEMATA for schema list queries instead of QSYS2.SCHEMATA.
- FIX: Script EXECUTE for Oracle procedures with STRING datatypes now scripts (2000) with initial length.
7.0.20
- FIX: SQL Server Procedure Editor/Debugger would fail when procedure had a parameter with BIT datatype
7.0.19
- FIX: Parameterized Scripts: Multiple /* */ comments in scripts would sometimes prevent parameterized script from running.
7.0.18
- 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.
7.0.17
- 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.
7.0.16
- 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.
7.0.15
- 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
7.0.14
- FIX: DB2 iSeries script properties where not configurable in File->Options->Scripts because they were not set.
- FIX: Tab Compare lists the tab full name with file name now.
- FIX: DB2 iSeries - Table extraction filtered on QSYS2.systables where TABLE_TYPE='T' ... now filters on (TABLE_TYPE = 'T' OR TABLE_TYPE = 'P')
- FIX: Right click menu on results grid shows default hot key (ctrl+shif+k) for results compare even when the hot key has been redefined by the user
- FIX: Don't show sybase explain plan I/O stats table if statistics IO not executed.
- FIX: Conditional DROP for MySQL and Postgresql had syntax error
- LOCALIZATION: Minor Updates
7.0.13
- 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
7.0.12
- 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 ...
7.0.11
- 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
7.0.10
- 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.
7.0.9
- FIX: Results Diff filter was displaying NULL values where no row should be.
- FIX: Server Registration: ODBC Datasource browser didn't work.
7.0.8
- FIX: Results Diff filter was not working.
- FIX: Garbage Collection button now also runs finalize.
- FIX: Sybase ASE: Explain Plan Statistics IO, remembers split position and Total is now first row.
- FIX: ER Diagram Generator is now a frame and can be minimized.
- 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: 54%
- (Status: Translating) Korean: 58%
- (Status: Translating) Chinese (Traditional): 50%
- (Status: Translating) Chinese (Simplified): 75%
7.0.7
- FIX: Option Dialog property heights didn't calculate correctly for big fonts
- FIX: Memory monitor bar was inverted for memory used.
- FIX: Server Registration: Oracle OCI: Now has work on driver compatibility.
7.0.6
- 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
7.0.5
- 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%
7.0.4
- 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
7.0.3
- FIX: ER Modeler: Generate DDL Script was scripting DROP of Primary Keys, but no longer does this as the DROP TABLE handles this.
- FIX: ER Modeler: Generate DDL Script dialog is no longer modal.
- FIX: Informix functions and procedures now are listed in schema browser correctly, as before some were missing.
7.0.2
- FIX: Query Analyzer: Table completion didn't show schema name.
- CHANGE: ER Modeler & Script Generator: Script Generation now scripts creation of table primary key embedded in CREATE TABLE statement.
Previously, a separate statement caused issues for MySQL with auto increments that require primary key to be defined on auto increment columns.
- FEATURE: Added Script CREATE & DROP menu items for Materialized Views for Oracle.
- FEATURE: Sybase ASE: Explain Plan Statistic IO grid now has aggregator, and logical IO is first column.
7.0.1
- 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%
7.0.0 - Release
- Change: Tagged as release
7.0.0.RC.15
- FIX: Editor: Opening Editor with initial file would have an initial Undo buffer that would clear the full text.
- FIX: Table Data Editor: foreground color of text for tabs was too light when the tab colors were user defined.
- FIX: Editor: Find Next selection was not invoked by hotkey (CTRL-F3 on Windows/Linux and CTRL-CMD-G on OSX)
- FIX: RunScript.bat/.sh was broken in RC.11, now fixed.
7.0.0.RC.14
- FEATURE: Added option to File->Option->General->Query Windows:Show File Name, Always, Never, When File Exists
- FEATURE: Sybase ASE : Execution of query with Show Explain enabled with now also "set statistics io on"
- FEATURE: Abbreviations, autocompletion now shows the Abbreviations in the autocompletion window as [Abbreviation - Expanded Text], instead of [Expanded Text - Abbreviation]
- FEATURE: Copy to Clipboard now works for the HTML and XML editors in addition to the SQL Editor.
- CHANGE: Disabled (temporarily) Syntax Coloring Copy to Clipboard because it disables the Paste Command
- LOCALIZATION: Update
- Spanish: 99%
- French: 99%
- Portuguese: 99%
- Italian: 99%
- Portuguese (Brazil): 99%
- German: 96%
- Japanese: 89%
- Russian: 1%
- Korean: 1%
- Chinese (Traditional): 1%
- Chinese (Simplified): 1%
7.0.0.RC.13:
- FIX: Sybase ASE: Script to Window -> CREATE DEFAULT would remove double quotes on a default value if created with double quotes.
- FEATURE: (Oracle) Detail View on Table Partitions have more information now.
- FEATURE: Grid Results popup menu: Converted "Copy As ..." menu for Horizontal/Vertical to a custom dialog with
options to choose Horizontal/Vertical, Delimiter, Quote Identifer and Enclosure.
- FEATURE: SQL Editor: Added basic support for copy to clipboard in RTF. This gives you syntax coloring for pasting to Wordpad.
7.0.0.RC.12:
- FEATURE: Enabled Evaluations
7.0.0.RC.11:
- FIX: Sybase ASE: Script Table CREATE (Full), applied condition on table lock type to determine parameters max_rows_per_page & exp_row_size
- FIX: Table Dialog: Adding new column and clicking on datatype wouldn't automatically create new empty row.
- FIX: Pivot Charts: Would include totals and subtotals, no longer.
- FIX: Query Window: Reexecution would not save position and settings for pivot and charts.
- FEATURE: Query Window & Query Builder: The default current folder for openning and saving files is superseded by the mounted folder
7.0.0.RC.10:
- FIX: Autocompletion now supprts table hints in SQL Server. ex: SELECT * FROM TABLE (NOLOCK) ^
- FEATURE: Tab Coloring: is now extended to Table Data Editor and Query Builder.
- FEATURE: Tab Coloring: Added smarts to use black or white color depending on the background luminosity, And shading of non active tabs.
- FEATURE: Abbreviations: Abbreviations are now saved in abbreviations.properties instead of datastudio.properties
so they may be pre-defined and distributed independant of datastudio.properties.
- FEATURE: Abbreviations: Autocompletion now also completes Abbreviations as long as you have one character typed,
and it completes on the abbreviation text and not the Expanded text.
- FEATURE: Tabs: Added CTRL-] as hotkey to pull down top right popup window for list of tabs.
- FEATURE: Tabs: Added "Tab Title Name" option in server registration to allow expressions for naming tab titles when they open.
- FEATURE: Import Tool: Added smarter auto-alignment of columns when importing file with column names.
7.0.0.RC.9: [Internal Build]
7.0.0.RC.8: Please see ... http://www.aquafold.com/d7/docs/index.html