Release Log

Version 6.7.1 ( Released on 08/18/2017)

Version 6.6.1 ( Released on 07/10/2017)

Version 6.5.1 ( Released on 06/22/2017)

Version 6.4.1 ( Released on 05/19/2017)

Version 6.3.1 ( Released on 04/26/2017)

Version 6.2.1 ( Released on 03/31/2017)

Version 6.1.1 ( Released on 01/29/2017)

Version 5.6.1 ( Released on 12/09/2016)

Version 5.5.1 ( Released on 11/18/2016)

Version 5.4.1 ( Released on 10/18/2016)

Version 5.3.1 ( Released on 09/01/2016)

Version 5.2.1 ( Released on 07/01/2016)

Version 5.1.1 ( Released on 04/12/2016)

Version 4.2.1 ( Released on 07/03/2015)

Version 4.1.1 ( Released on 03/27/2015)

Version 4.0.1 ( Released on 02/16/2015)

Version 4.0.0 ( Released on 12/26/2014)

Version 3.9.2 ( Released on 12/02/2014)

Version 3.9.1 ( Released on 11/06/2014)

Version 3.8.2 ( Released on 10/15/2014)

Version 3.8.1 ( Released on 09/26/2014)

Version 3.7.2 ( Released on 09/05/2014)

Version 3.7.1 ( Released on 08/22/2014)

Version 3.6.2 ( Released on 08/10/2014)

Version 3.6.1 ( Released on 07/26/2014)

Version 3.5.1 ( Released on 06/28/2014)

Version 3.4.3 ( Released on 04/25/2014)

Version 3.4.2 ( Released on 04/10/2014)

Version 3.4.1 ( Released on 03/22/2014)

Version 3.3.1 ( Released on 03/03/2014)

Version 3.2.1 ( Released on 02/22/2014)

Version 3.1.1 ( Released on 02/08/2014)

Version 3.0.2 ( Released on 01/01/2014)

Version 3.0.1 ( Released on 12/22/2013)

Version 3.0.0 ( Released on 12/12/2013)

Version 2.11.1 ( Released on 10/12/2013)

Version 2.10.2 ( Released on 9/29/2013)

Version 2.10.1 ( Released on 9/16/2013)

Version 2.9.1 ( Released on 9/1/2013)

Version 2.8.1 ( Released on 7/28/2013)

Version 2.7.1 ( Released on 7/7/2013)

Version 2.6.1 ( Released on 6/22/2013)

Version 2.5.1 ( Released on 5/22/2013)

Version 2.4.1 ( Released on 4/22/2013)

Version 2.3.1 ( Released on 3/28/2013)

Version 2.2.1 ( Released on 3/3/2013)

Version 2.1.1 ( Released on 2/3/2013)

Version 1.2.1 ( Released on 1/8/2013)

Version 1.1.2 ( Released on 8/28/2012)

Version 1.1.1 ( Released on 6/18/2012)

Version 1.0.1 ( Released on 4/6/2012)

Version 6.7.1

Enhancement

• Add tablespace to Oracle database
• Save script panel automatically if it is changed
• Selected next script panel if current is closed
• Selected new added script panel

Bug

• Building SQL cannot show result

Version 6.6.1

Enhancement

• Show the number of insert/update/delete rows in the result when execute sql
• Add file extension to exporting file automatically
• Load last exporting file path

Bug

• Change the exporting file selecting button to 'Save'

Version 6.5.1

Enhancement

• Prompt to save sql scripts before close
• Display connection info after db is connected

Bug

• 'Filter & Sort' does not remove ','
• Fix oracle constraint script
• Oracle does not display constrain script

Version 6.4.1

Enhancement

• Support to change the color of 'Filter & Sort'
• Add scroll panel for color configurationn
• Improve the performance to free system memory

Bug

• Fix exporting data issue
• Correct exporting file existing message
  

Version 6.3.1

Enhancement

• Improve table data fetching performance
• Improve exporting data performance
• Add tab tips to sql result
• Pop up time picker when edit table date cell

Bug

• Database disconnection causes script panel refresh issue
  

Version 6.2.1

Enhancement

• Scroll to selected row after data is updated or refreshed
• Upgrade attached jdbc jar files

Bug

• Oracle date update issue
• Exporting SQL result does not match the select database connection
• Set current timestamp issue
  

Version 6.1.1

Enhancement

• Improve performance to close DtSQL
• Enable search function in components like script and table
• Cache the location of last open file/folder
• Load script content of last exit
• Receive enter event to do search

Bug

• Save the changes of Oracle timestamp
• Change export file button
  

Version 5.6.1

Enhancement

• Improve auto complete performance
• Improve exporting data performance
• Provide information for each 10000 exporting records
• Show table loading status

Bug

• Fix the issue if sql end with semicolon

Version 5.5.1

Enhancement

• Support max rows in exporting table data
• Support export data of multiple SQLs
• Shows last record in the log panel

Bug

• Applied table filter does not work after the connection name is changed
• Connection panel does not show selected connection after name is changed.
  

Version 5.4.1

Enhancement

Bug

• Only one connection node can show its color panel
• SQL Script does not workif it is end with mixed (\r \n and \r\n)
• Oracle number values show in double format
• Fix Oracle dup column info
• Fix Oracle saving changed data

Version 5.3.1

Enhancement

• Change SQL script break to blank row
• Enable to show script of the SQL result
• Enable to set different color for DB connections

Bug

• Show selected table when import data from file

Version 5.2.1

Enhancement

• Enable sort connection nodes
• Provide package body for Oracle DB
• Provide type body for Oracle DB

Bug

• Fix the issue to display Oracle package script
• Fix the issue to display Oracle type script

Version 5.1.1

Enhancement

• Click db search result to show selected db object
• Enhance oracle supported data types

Bug

• Update the numberic value if table is in unformatted pattern
• Filter & sort does not work in some oracle table
• UPdated values cannot be save in Oracle

Version 4.1.1

Enhancement

• Improve the performance to free memory

Bug

• Keep the button to add new sql editor after close all sql editors

Version 4.0.1

Enhancement

Bug

• Merge same SQL prompt variables
• Skip commented out SQL prompt variables
• Correct production updating version
• Save preference value if any is updated

Version 4.0.0

Enhancement

• Support call oracle and postgres procedures and functions
• Request 20-day trial license online by valid email address
• Update SQLite jar file

Bug

• Procedure/function parameters are not loaded properly
• File name is not added to new SQLIte connection URL
• Disable loading action if the table is being loaded
• Trial license expired issue

Version 3.9.2

Enhancement

• Enable to select specified variable in variable bound function
• DB2: show Java stored procedure script

Bug

• Variable bound does not work if variable is within parentheses

Version 3.9.1

Enhancement

• Enable to add new SQL Editor in the tab like IE
• Enable to change memory size
• Add SQL variable bound prompt function
• Recycle memory when application is free

Bug

• Disable result tool bar setting value button if table is not editable

Version 3.8.2

Enhancement

• Oracle: add table partition, subpartition, statistics
• Oracle: add Clusters, DB Links, Jobs, Types, Packages, Queues, Queue Tables and Rules,
• MySQL: add table partition & statistics, Collation, Engine, Status and Variable

Bug

• Oracle: synonym node link
• Format error message

Version 3.8.1

Enhancement

• Search database objects

Bug

• Selected db object node is reset if a new db object is created
• Index creating panel does not show selected table node information
• Change column data type in table altering panel
• Connection searching field does not show properly in Linux
• Exporting data panel does not show column name properly
• Exporting data panel does not show configuration properly

Version 3.7.2

Enhancement

• Show message if try to export MongoDB data to SQL file.

Bug

• MariaDB : display users
• MongoDB : exporting record count is not correct
• MongoDb : imports data to table
• The column width value is reset after tab switched if importing data format is 'fixed col width'

Version 3.7.1

Enhancement

• Support new database MariaDB

Bug

• MongoDb: add new column if the table only has one column
• MySQL: add new record to the table if it has primary ke

Version 3.6.2

Enhancement

• Enable the panel to import data to tables
• MongoDb: add new column, import data to table

Bug

• MongoDb: add new column to a new new table
• MongoDB: fail to 'test' after the new connection is added

Version 3.6.1

Enhancement

• Support new database MongoDB
• Enhance DtSQL look and feeling

Bug

Version 3.5.1

Enhancement

• Alert Table: rename table/columns, change column data type, add/drop constraints/indexes
• Create table: enable deleting selected new columns

Bug

• Index DDL tabs do not show script properly

Version 3.4.3

Enhancement

• Upgrade JRE to version 1.7.0 on Windows & Linux systems
• Upgrade DB2 JDBC driver jar file

Bug

• Table DDL tab does not show script properly

Version 3.4.2

Enhancement

• Add new option to refresh table result automatically
• Enhance function to export single table/mutiple tables/SQL

Bug

• Export sql result to CSV file

Version 3.4.1

Enhancement

• Right click the tab to close/close others/close all sql result/sql editors
• Add new tool buttons to load executed SQL to editor
• Support exort data to PDF file

Bug

• Automatic completion can not recognize the word after backspace
• Copy/Paste hot key in SQL Editor do not work
• Prompt dialog is not popped up if the SQL editor is closed

Version 3.3.1

Enhancement

• Support drop and open file in SQLEditor
• Support quoted schema and table names in automatical completion

Bug

• Editor automatic completion does not list selected table columns properly
• SQL Editor does not show file name properly
• SQL Editor does not show SQL execution log properly

Version 3.2.1

Enhancement

• Set the editor title name to selected database name
• Support add/close multiple SQL editors
• Support quoted table name in editor automatic completion

Bug

• Editor automatic completion does not list all matched alias table columns
• SQL Editor Home/End key does not work properly
• First line in the selected block is not commented

Version 3.1.1

Enhancement

• Support export Binary/Blob to file
• Support import file data to table Binary/Blob/Clob column
• Improve automatic completion function
• Improve table data exporting functions
• Show log information if there is no executing result returned
• Log sql executing and result fetching time

Bug

• PostgreSQL: auto completion does not show table column name properly

Version 3.0.2

Enhancement

• Support SQLServer 2008
• Add ew option to enable page function
• Improve the result loading performance
• Add sequece DDL : postgresql, db2
• Db2: add Global Temporary Tables
• Add row count for tables & views
• Show the information tab if any database object is selected
• Building SQL : enable select two table columns for select

Bug

• Db2 : alias display issue
• PostgreSQL: user name display issue

Version 3.0.1

Enhancement

Bug

• Error on automatical version update

Version 3.0.0

Enhancement

• Provide first official release and free version
• Enable to load the table next page records
• Create a new thread to load ER-Diagram
• Format selected SQL text : SQLEditor->Right Click to Pop Menu->Format Selected SQL
• Show loading status while the SQL is executing

Bug

• DB2: fix building SQL issue for specific table names
• MySQL: show table information

Version 2.11.1

Enhancement

• Add uncomment line function
• Enable inverse row selection on result grids
• Search Column Names (columns will be selected if the column names are matched)
• HSQLDB: add grant for table columns
• DB2: add grant for indexes, functions, procedures, sequences
• MySQL: add grant for table columns
• PostgreSQL: add grant for table columns and functions

Bug

• Issue to add constraints for an existing table

Version 2.10.2

Enhancement

• Provide SQL executing time
• New option is added to table popmenu to show executing SQL
• Keep the processing circle always on the top

Bug

• The 'explain select' does not work properly in the SQLEditor
• If the query is too large, the cross button (to close that result tab) is not visible
• Application has to be restarted if Auto complete hot key is changed
• Import tool doesnot work properly in SQLSErver 2008

Version 2.10.1

Enhancement

• Support explain/analyze plan SQL
• Support export schema table, view, index, trigger, procedure and function DDLs
• Add new function in table popmenu to select entire column
• Mimer: enable display data banks
• MySQL: enable display schedule events
• Create seperated SQL editor
• Populate the selected text to the searching panel

Bug

• Replace all function does not work properly
• Table create & drop statements are not included in the export SQL data file.

Version 2.9.1

Enhancement

• Register hot key (Ctr+Enter) for 'execute current'
• Provide 2 options to copy selected table data : "copy rows" (Ctr+C) and "copy rows with headers" (Ctr+Shft+C).
• Provide memory usage indicator
• Add new button to call garbage recycle
• Create seperated SQL editor
• Pop up individe result table for each SQL
• Show table/view grant information
• Provide new tab panel to show table information
• Provide new tab panel to show table/view DDL

Bug

• Table column sorting function does not work properly
• HSQLDB does not show view DDL correctly

Version 2.8.1

Enhancement

• Add ( Ctrl + Enter ) to execute current SQL
• Add new function to change the key to execute SQL and trigger SQL Editor Auto Coplete. (Prefererences->Key)
• Add new buttons to convert SQL Editor characters to lower case and reverse
• Add 'Goto Line' button in SQL Editor
• Add line number to DDL text area (trigger, procedure, function and so on)
• Add loading progress while copying selected table data
• Cache and save each table filter and sort sql
• Add 'Reset' button to 'Filter & Sort' panel
• Support export system information

Bug

• 'Replace' does not show the changed characters in SQL Editor
• View script is not formatted and showed in one line
• MySQL does not show view in information schema
• Db2 does not show procedure DDL

Version 2.7.1

Enhancement

• Code completion on database name, table name, column name,function name (Ctrl + W)
• Add built-in database HSQLDB without any configuration
• Click table line number to select the whole row
• Click table top corner to select all table rows

Bug

• Sort records in table by column name

Version 2.6.1

Enhancement

• Support filter data object tree
• Support filter table data
• Support insert Blob/Binary data from files

Bug

• Insert new record row and duplicate record row

Version 2.5.1

Enhancement

• Provide new panel to insert index
• Provide new panel to insert trigger
• Display database catalog for H2 and HSQLDB
• Provide new panel to insert constraint (primary key, foreigh key, check and unique constraint)

Bug

• Dtsql batch file does not load correct JRE
• Popmenu on two different database shows the same content

Version 2.4.1

Enhancement

• Support creating index, trigger and constraint in table creating function
• Moved creating connection item to the first one of the pop menu
• Display database catalog for H2 and HSQLDB
• Prompt to create a new database connection if there is no connection
• Provide the link to User's Guide in the first installtion
• Provide help on how to create database connection and where to download JDBC jar files

Bug

• Table tool bar buttons are not set properly before table data is displayed
• FireBird : display table and view information
• Column default value does not work in creating new table
• PostgresSQL : referenced keys are not correct in the foreign keys
• Creating table : the not-null is not selected when primary key option is select

Version 2.3.1

Enhancement

• Provide table pop menu to copy and selected cell or row
• Enhance Oracle creating table
• Display H2 and Derby system table information

Bug

• Db2: error creating column for 'bit data'
• H2: can not display all table information
• Derby: altering view does not work

Version 2.2.1

Enhancement

• Copy the table in the same database
• Display and edit table records in the same panel

Bug

• Importing data for table does not show the right table name in the populating panel.
• Error to insert multiple records in MySQL
• The sensitive value can be found in Table data search
• Db2 receives error when creating table with enhanced parameters

Version 2.1.1

Enhancement

• Support free version

Bug

• Error in creating DB2 table
• Error in importing data to DB2 table
• Enable save button after table data is changed

Version 1.2.1

Enhancement

• Support DB2 user, role, buffer pool, package, DB partition group and tablespace objects
• Support PostgresSQL user, role, aggregate, cast, conversion, doamin, language, operator, operator class, operator family, rule, tablespace and type objects
• Enhance DB2, PostgresSQL, and MySQL creating table function

Bug

• Error to display sample DDL to import data to table
• Refresh the table data after the changed data is saved
• Refresh the table after the table data is truncated
• Search the table data after enter the search value

Version 1.1.2

Enhancement

• Support PostgreSQL 9.x version
• Show script to create database object

Bug

• Scroll to the first line when show SQL script
• Some function or procedure can not be modified
• The script in the view textarea is editable
• Function script does not show parameters
• Omit function parameter name if it is null PostgreSQL
• Set old object name as default value when rename database object

Version 1.1.1

Enhancement

• Save config data, license and log data to local driver

Bug

• Connect all database connections at the same time
• Formatting SQL drops last semi-comma

Version 1.0.1