Softpedia >Windows >Portable Software >Database Utils >DtSQL Portable >  Changelog

DtSQL Portable Changelog

What's new in DtSQL Portable 6.7.1 Build 20170818

Aug 19, 2017
  • 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

New in DtSQL Portable 6.6.1 Build 20170707 (Jul 11, 2017)

  • 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'

New in DtSQL Portable 6.5.1 Build 20170622 (Jun 23, 2017)

  • 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

New in DtSQL Portable 6.4.1 Build 20170519 (May 21, 2017)

  • 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

New in DtSQL Portable 6.3.1 Build 20170426 (Apr 26, 2017)

  • 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

New in DtSQL Portable 6.2.1 (Apr 1, 2017)

  • 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

New in DtSQL Portable 6.1.1 Build 20170125 (Jan 30, 2017)

  • 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

New in DtSQL Portable 5.6.1 Build 20161209 (Dec 12, 2016)

  • 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

New in DtSQL Portable 5.4.1 Build 20161118 (Nov 21, 2016)

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

New in DtSQL Portable 5.4.1 Build 20160701 (Nov 21, 2016)

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

New in DtSQL Portable 5.3.1 Build 20160701 (Nov 21, 2016)

  • 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

New in DtSQL Portable 5.2.1 Build 20160701 (Jul 1, 2016)

  • 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

New in DtSQL Portable 4.2.1 Build 20150703 (Jul 4, 2015)

  • Enhancement:
  • Import DtSQL properties from file
  • Export DtSQL properties to file
  • Improve the performance to free memory

New in DtSQL Portable 4.1.1 Build 20150327 (Mar 28, 2015)

  • Enhancement:
  • Improve the performance to free memory
  • Bug:
  • Keep the button to add new sql editor after close all sql editors

New in DtSQL Portable 4.0.1 Build 20150216 (Feb 17, 2015)

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

New in DtSQL Portable 4.0.0 Build 20141226 (Feb 17, 2015)

  • 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

New in DtSQL Portable 3.9.2 Build 20141202 (Dec 2, 2014)

  • 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

New in DtSQL Portable 3.9.1 Build 20141015 (Nov 6, 2014)

  • 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

New in DtSQL Portable 3.8.2 Build 20141015 (Oct 15, 2014)

  • 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

New in DtSQL Portable 3.8.1 Build 20140928 (Sep 27, 2014)

  • 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

New in DtSQL Portable 3.7.2 Build 20140905 (Sep 6, 2014)

  • 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'

New in DtSQL Portable 3.7.1 Build 20140822 (Sep 1, 2014)

  • 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

New in DtSQL Portable 3.6.2 Build 20140810 (Aug 11, 2014)

  • 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

New in DtSQL Portable 3.6.1 Build 20140726 (Jul 27, 2014)

  • Enhancement:
  • Support new database MongoDB
  • Enhance DtSQL look and feeling

New in DtSQL Portable 3.5.1 Build 20140628 (Jun 30, 2014)

  • 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

New in DtSQL Portable 3.4.3 Build 20140425 (Apr 26, 2014)

  • 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

New in DtSQL Portable 3.4.2 Build 20140410 (Apr 11, 2014)

  • 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

New in DtSQL Portable 3.4.1 Build 20140322 (Mar 24, 2014)

  • 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

New in DtSQL Portable 3.3.1 Build 20140301 (Mar 2, 2014)

  • 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

New in DtSQL Portable 3.2.1 Build 20140222 (Feb 24, 2014)

  • 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 complate 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

New in DtSQL Portable 3.1.1 Build 20140208 (Feb 10, 2014)

  • 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

New in DtSQL Portable 3.0.2 Build 20140101 (Jan 3, 2014)

  • 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

New in DtSQL Portable 3.0.1 Build 20131222 (Dec 23, 2013)

  • Bug:
  • Error on automatical version update

New in DtSQL Portable 3.0.0 Build 20131212 (Dec 23, 2013)

  • 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

New in DtSQL Portable 2.11.1 Build 20131012 (Dec 13, 2013)

  • 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

New in DtSQL Portable 2.10.2 Build 20130929 (Sep 30, 2013)

  • 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

New in DtSQL Portable 2.10.1 Build 20130916 (Sep 30, 2013)

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

New in DtSQL Portable 2.9.1 Build 20130902 (Sep 2, 2013)

  • Enhancement:
  • Register hot key (Ctr+W) 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

New in DtSQL Portable 2.8.1 Build 20130728 (Jul 30, 2013)

  • 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

New in DtSQL Portable 2.7.1 Build 20130707 (Jul 6, 2013)

  • 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

New in DtSQL Portable 2.6.1 Build 20130622 (Jun 24, 2013)

  • 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

New in DtSQL Portable 2.5.1 Build 20130522 (May 23, 2013)

  • 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

New in DtSQL Portable 2.4.1 Build 20130422 (Apr 23, 2013)

  • 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

New in DtSQL Portable 2.3.1 Build 20130328 (Mar 31, 2013)

  • 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

New in DtSQL Portable 2.2.1 Build 20130302 (Mar 7, 2013)

  • Feature:
  • 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

New in DtSQL Portable 2.1.1 Build 20130202 (Feb 19, 2013)

  • Feature:
  • Support free version
  • Bug:
  • Error in creating DB2 table
  • Error in importing data to DB2 table
  • Enable save button after table data is changed

New in DtSQL Portable 1.2.1 Build 20130108 (Jan 16, 2013)

  • Feature:
  • 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

New in DtSQL Portable 1.1.2 Build 20120828 (Sep 3, 2012)

  • Feature:
  • 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

New in DtSQL Portable 1.1.1 Build 20120618 (Jun 16, 2012)

  • Feature:
  • 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