XmlToMsSql 3.3 Released Download

2022/05/29
V3.3 Released
Merged to FileToDB.

2022/03/11
V3.2 Released
Fix detect BOM.
Fix parse date format in file when creating table.
Fix read long line file.
Fix write bad file.
Improve display progress for estimated rows.
Improve import number to db.
Improve insert/update to SQL Server.
Improve read XML with sublevel.

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

2021/12/24
V3.0 Released
Add suport Linux.
Add suport macOS.
Fix "create table".
Improve read XML file performance.

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

2021/03/19
V2.5 Released
Improve LOB read/write performance.
Improve importing performance.

2021/02/17
V2.4 Released
Add "run a task every n hours".
Add "run a task every n minutes".

2021/01/05
V2.3 Released
Add "Save To SQL File".
Improve data convert performance.

2020/11/01
V2.2 Released
Add "Record On" to support more complex XML importing.
Add support to SQL Server 2019.
Fix XML read first node.
Fix XML read node has value, has attributes, has no child.
Fix adjust table list width.
Fix move files after importting.
Improve deal with not invalid XML format file.

2020/04/08
V2.1 Released
Add option "source filename as column"
Add parse "US$" format string to number.
Improve map columns.

2019/07/19
V2.0 Released
Fix a file choose bug.
Fix a folder choose bug.
Fix an SSL connect issue.
Improve importing performance.

2019/04/10
V1.9 Released
Fix a performance problem cause by too many small files.
Fix the problem about duplicate node names.
Improve read XML file performance.

2018/08/01
V1.8 Released
Add suggest data type on creating table.
Fix write empty string to CLOB/TEXT field.
Improve convert with large column count.
Improve read long text in XML.

2018/03/19
V1.7 Released
Add "upsert" mode import.
Improve "update" mode import, update key must be unique index.
Improve XML source view.
Improve for XML duplicate column.

2017/12/01
V1.6 Released
Add view TEXT(CLOB) by mouse click.
Fix import string contains single quote.
Fix load data to ftVarBytes field.

2017/04/18
V1.5 Released
Add "move successful files to another folder" function.
Add convert data from web.
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 support to convert both from XML child elements and attributes.
Add support to convert from n sub-level XML child elements.
Add view target table after importing.
Fix bug on source data file name has no ext.

2016/11/11
V1.4 Released
Add "Show table DDL".
Fix import date with format "YYYYMM".
Fix import date/integer/float/bool data bug when data is "N/A".
Fix import long string to varchar field bug.
Fix import to SQL Server identity field bug.
Improve wizard form UI.

2016/08/12
V1.3 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/06/22
V1.2 Released
Add support importing data to field that field name contains "~".
Add support to more number formats.
Adjust login form.
Improve command line, made it more simple.
Improve parsing date format.
Improve parsing number format.
Improve support to importing unicode data to SQL Server varchar(MAX)/nvarchar(MAX) field.

2016/03/12
V1.1 Released
Add "Import from attribute".
Add set default field type on creating table.
Improve support to importing empty string data to not null field.

2015/07/15
V1.0 Released
First Release.


	

---