Universal Database Tools - DtSQL Logo
  Site Map
 
   
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL navigator box   Home Universal Database Tools - DtSQL navigator box   Features Universal Database Tools - DtSQL  navigator box   Download Universal Database Tools - DtSQL  navigator box   Purchase Universal Database Tools - DtSQL  navigator box   Support Universal Database Tools - DtSQL  navigator box   Contact Universal Database Tools - DtSQL  navigator box   Events
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
 

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

 

 


Copyright © DigerTech Inc