Import XML into SQL Server using Exult: Recent Changes

Recent Changes to the Exult SQL Server

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.