Withdata Software

AccessToDB2 5.3 Released Download 
2022/05/26
V5.3 Released
Merged to DBCopier.

2022/03/11
V5.2 Released
Fix parse date format in file when creating table.
Fix write bad file.
Improve display progress for estimated rows.

2022/02/02
V5.1 Released
Improve create batch file for running scheduled task on Windows.

2021/12/30
V5.0 Released
Fix "create table".
Improve converting performance.

2021/07/28
V4.2 Released
Fix bugs caused by incompatible library version.
Improve create table.

2021/03/19
V4.1 Released
Improve importing performance.

2021/02/24
V4.0 Released
Add "run a task every n hours".
Add "run a task every n minutes".

2021/01/05
V3.9 Released
Add "Save To SQL File".
Fix view target table data on transfer tables.
Improve data convert performance.

2020/11/01
V3.8 Released
Fix adjust table list width.
Fix bug in batch transfering data from tables when target table name not same as source table name.

2020/04/15
V3.7 Released
Improve import part rows and skip rows.
Improve map columns.

2019/07/19
V3.6 Released
Improve importing performance.
Some other bug fixes and enhancements.

2018/08/02
V3.5 Released
Add convert "Struct Only".
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.

2018/03/19
V3.4 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve performance by build index after convert.

2017/12/01
V3.3 Released
Fix import string contains single quote.
Fix load data to ftVarBytes field.

2017/06/14
V3.2 Released
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.

2016/11/12
V3.1 Released
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.

2016/08/22
V3.0 Released
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.

2016/07/20
V2.9 Released
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.
Improve support to importing unicode data to DB2 CLOB field.

2016/03/14
V2.8 Released
Add UseUnicode options to DB2, improve unicode support to DB2.
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 DB2 can not get schema names.
Improve support to importing empty string data to not null field.

2015/07/20
V2.7 Released
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.

2015/03/27
V2.6 Released
Add "Show scheduled tasks".
Add notify when load multiple data to one field at same time.
Add support create table on non-default schema.
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" .
Fix bug on changing target schema.
Improve convert performance significantly.

2015/01/26
V2.5 Released
Add "Create bad file for failed convert records".
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".
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.

2014/11/07
V2.4 Released
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.

2014/08/13
V2.3 Released
Add "turning off log" in command line.
Fix bug "failed load part columns data in command line".

2013/8/20
V2.2 Released.
Add "Task Schedule".
Add support to DB2 XML type field.
Improve import performance.
Fix "division by zero" bug in importing process.

2013/6/4
V2.1 Released.
Add "Execute Sql from Command line".
Add "Check Update" to menu.
Improve importing performance.
Improve logon form.
Fix "Execute update sql error".
Fix "Save To Sql" with "Update" type. 
Some other bug fixes and enhancements.

2013/2/4
V2.0 Released.
Imporve user interface.
Imporve performance.
Some bug fixes and enhancements.

2012/9/25
V1.8 Released.
Add "Make Batch File".
Add "Date Format Config".
Improve "Export From Query".
Some other bug fixes and enhancements.

2012/3/15
V1.7 Released.
Add "right click tab to rename/close form".
Add compatible to some old version DB2.
Improve "progress update".
Some bug fixes and enhancements.

2011/9/17
V1.6 Released.
Improve "Logon", now can connect to DB2 with installing only DB2 CLI/ODBC Driver.
Add "Logon DB2 by hostname, port and server name".
Some bug fixes and enhancements.

2011/7/7
V1.5 Released.
Add "Auto create table" to "Import All Tables".
Add wizard to "Import All Tables".

2011/5/23
V1.4 Released.
Add wizard to "Import From Table" and "Import From Query".
Imporve user interface.
Some bug fixes and enhancements.

2011/3/17
V1.3 Released.
Add "WordWrap" option to Query form and "Import From Query" form.
Fix bug about "copy/paste with TAB in Query form".

2010/10/25
V1.2 Released.
Add "Execute via command line" , enable automate exporting task.

2010/8/26
V1.1 Released.
Add launch window.
Improve "save/load session".
Improve query form.

2010/8/2
V1.0 Released.
First Release.