What's new in DtSQL 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 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 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 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 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 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 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 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 5.5.1 Build 20161118 (Nov 18, 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 5.4.1 Build 20161018 (Nov 18, 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 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 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 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 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 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 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 3.9.1 Build 20141102 (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 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 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 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 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 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 3.6.1 Build 20140726 (Jul 27, 2014)
- Enhancement:
- Support new database MongoDB
- Enhance DtSQL look and feeling
New in DtSQL 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 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 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 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 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 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 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 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 3.0.1 Build 20131222 (Dec 23, 2013)
- Bug:
- Error on automatical version update
New in DtSQL 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 2.11.1 Build 20131012 (Oct 12, 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 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 2.10.1 Build 20130916 (Sep 17, 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 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 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 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 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 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 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 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 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 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 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 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