Import XML into SQL Server using Exult: Recent Changes

Recent Changes to the Exult SQL Server

Aug 21, 2008

Exult Profession Edition for SQL Server version 1.7 released.

Bug fix: properly adjusting column sizes when repeated element or attributes are found in the XML.

June 28, 2008

Exult Profession Edition for SQL Server version 1.6 released.

Added option to the command line program to force loading of duplicate XML files added to the command line interface program. By default, Exult computes the SHA1 checksum for an XML file and does not load the file into the database if it has been loaded previously. An option has been provided to override this behaviour and load files regardless of whether they have been loaded previously.

May 28, 2008

Exult Profession Edition for SQL Server version 1.5 released.

Bug fix for SQL Server 2000 for avoiding SQL Server Error code 4928 when processing XML file (changing column type to NTEXT when it is already NTEXT. Should be ignored).

Mar 16, 2008

Exult Profession Edition for SQL Server version 1.4 released.

Bug fix in handling multi-threading.
Connection issue on Windows Server 2003 fixed.
Querying a non-existent table on Windows Server 2003 causes a crash. Fixed to check for existence of the table before querying it.

Feb 27, 2008

Exult Profession Edition for SQL Server version 1.3 released.

Quoting table and column names properly to allow use of SQL Server keywords for these.

Feb 06, 2008

Exult Profession Edition for SQL Server version 1.2 released.

Improved support for downloading XML from remote locations.
Debug output can optionally be written to a log file.
After successfully importing the XML into SQL server, a message window is shown which informs the user of this fact. This is required since loading the data from the database for preview could take some time if the data is large.
Fix in computing the XPath of an attribute.

Nov 25, 2007

Exult Profession Edition for SQL Server version 1.1 released.

Support for directly reading HTTP and FTP urls added.
Can easily import and update XML feeds.
One-click refresh of data from XML that has already been imported. Uses SHA checksum to check that the XML has changed before importing.
Enhanced the command line to not require any file or URL input when operating in feed update mode. In this case, all the XML documents imported into the database are refreshed. If any document has not changed, it is not modified.
Bug fix: Change in case of XML element names taken care of by checking column names without regard to case since database column names are case-insensitive.

Oct 02, 2007

Exult Profession Edition for SQL Server version 1.0 released.

Exult Profession Edition for SQL Server is a Wizard Application which makes it very easy to import data from XML files into an SQL Server database.
Data is imported into tables which are created to reflect the structure of XML.
Hierarchical XML structure is maintained by using primary and foreign keys to link parent and child tables.
Easily handles complex XML files as well as simple ones.
Can load huge files without running into memory issues since it does not load entire files into memory at once.
Merges data from multiple XML files and imports the data into the database.
Imports Attribute information too when loading XML.
Has a familiar and easy-to-use Wizard Interface which steps you through the data extraction.
Includes a command-line interface to help with batch processing.