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 3.5.1 ( Released on 04/25/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 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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

Version 3.0.1

Enhancement

Bug

  • Error on automatical version update
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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.
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

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
TOP
 

Version 1.0.1

 

 

TOP

Copyright DigerTech Inc