2.2 Released Download
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve performance by build index after convert.
Fix import string contains single quote.
Fix load data to ftVarBytes field.
Add "transfer N tables data to 1 table".
Add handle for skip rows big than total rows.
Add support date format like: "20150101 13:43:29".
Add support date format like: "2016-04-12T18:37:09-07:00".
Add support date format like: "2016-07-21T17:18:52Z".
Add support date format like: "Fri, 21 Oct 2016 13:08:32 +0800".
Add support date formats like: "2015:06:21", "2015:06:21 08:02:48", "2016:03:20 20:08:08-06:00".
Add view TEXT(CLOB) by mouse click.
Add view target table after importing.
Add "Show table DDL".
Fix convert data from view.
Fix export query results that can not count records.
Improve convert combine primary key.
Improve wizard form UI.
Add "Create Table" on right click menu.
Add "Database Object TreeView".
Add "Drop Table" on right click menu.
Add "View Table Data" on right click menu.
Add "View Table Struct" on right click menu.
Add "Set default value for field" on creating table.
Add support converting index, primary key, and default value on creating tables.
Add support importing data to field that field name contains "~".
Adjust login form.
Improve command line, made it more simple.
Improve converting data type on creating table.
Add support importing data to field that field name contains "&".
Fix bug that caused by break line in sql query.
Improve auto create table contains GUID field.
Improve support to importing empty string data to not null field.
Add auto parsing datetime format when create new table in batch convert.
Add support to field contains "<" or ">".
Add support to field contains line break.
Fix bug at click config button on batch converting tables.
Fix bug at converting data to created table that source table name contains special characters.
Fix bug at create table when batch converting tables to no-default schema.
Fix bug on edit data in resultset grid.
Improve execute in command line, will close if can not login database.
Improve support for more datetime format.
Improve support for more large integer field.
Add "Show scheduled tasks".
Add SQLite boolean type to create table.
Add notify when load multiple data to one field at same time.
Add support to Netherland number(currency) format like "96.325,75-".
Add support to date format like "22.12.2005." and "25.7.2008. 21:15:05" .
Improve convert performance significantly.
Add "Create bad file for failed convert records".
Add "Create new SQLite DB file".
Add "Login to encrypted SQLite file".
Add command-line and schedule task support to "save to sql".
Add notify when can not create log file.
Disable exception window when run in command-line.
Fix bug about can not close form when exception raise.
Fix bug on "change schema in importing tables to tables".
Fix bug on "export single table" with clob field.
Imporve "Create Table" on "Import All Tables", auto fix table name on creating.
Imporve "Create Table", auto fix table/field name before create.
Imporve datetime convert support.
Imporve notify when can not create session file.
Improve support for create table from query.
Improve "create target table", target table name auto change to created table.
Change reg code to license file.
Fix bug "create tables error" on "Import data from tables to tables".
Improve save session file, auto add folder and ext.
Improve exception report.
Improve Access logon form, auto remove the non-exists Access file name from history list.
Fix bug "logon to Access form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Fix bug "logon to SQLite form UI misalignment" caused by selecting a custom DPI setting that is higher than the standard 96 DPI.
Improve Sqlite logon form, auto remove the non-exists Sqlite file name from history list.
Add "turning off log" in command line.
Fix bug "failed load part columns data in command line".