Withdata Software

MsSqlToOracle 4.3 Released Download 
2022/05/26
V4.3 Released
Merged to DBCopier.

2022/03/11
V4.2 Released
Fix parse date format in file when creating table.
Fix write bad file.
Improve display progress for estimated rows.
Improve insert/update to SQL Server.

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

2021/12/30
V4.0 Released
Add "SSH tunnel connect" to Oracle.
Add connecting to Oracle by service name through "TCP/IP connect".
Add suport Linux.
Add suport macOS.
Fix "create table".
Improve converting performance.

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

2021/03/19
V3.2 Released
Add support to Oracle 21c.
Improve LOB read/write performance.
Improve importing performance.

2021/02/24
V3.1 Released
Add "run a task every n hours".
Add "run a task every n minutes".

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

2020/11/01
V2.9 Released
Add support to Oracle 20c.
Add support to SQL Server 2019.
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
V2.8 Released
Add support to Oracle 19c.
Improve import part rows and skip rows.
Improve map columns.

2019/07/19
V2.7 Released
Improve importing performance.
Some other bug fixes and enhancements.

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

2018/03/19
V2.5 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
V2.4 Released
Fix import string contains single quote.
Fix load data to ftVarBytes field.

2017/06/14
V2.3 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
V2.2 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 fetch Oracle SERVICE_NAME and SID.
Improve wizard form UI.

2016/08/22
V2.1 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.0 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 Oracle CLOB/NCLOB field.

2016/03/14
V1.9 Released
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.

2015/07/20
V1.8 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
V1.7 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.
Fix import error when Oracle table name is lower case.
Fix import error when field name is Oracle reserved keyword.
Improve convert performance significantly.

2015/01/26
V1.6 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".
Fix bug on import/export data when schema/table/field name contains double quote.
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 Oracle 11g 11.2.0.4.
Improve support for create table from query.

2014/11/07
V1.5 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 support to Oracle 12C.

2014/08/13
V1.4 Released
Add "turning off log" in command line.
Fix bug "failed load part columns data in command line".
Fix bug when logon to SQL Server name with "\".

2013/8/20
V1.3 Released.
Add "Task Schedule".
Improve import performance.
Fix "division by zero" bug in importing process.

2013/6/4
V1.2 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.

2012/9/28
V1.1 Released.
Add "Make Batch File".
Add "Date Format Config".
Improve "Import From Query".
Some other bug fixes and enhancements.

2012/6/6
V1.0 Released.
First Release.