Recent Changes to Exult SQL Server
Exult SQL Server 2.0
July 8, 2012
Exult Profession Edition for SQL Server version 2.0 released.
- Major update resulting in large performance improvement when
processing multiple XML files.
- Optimized for importing XML into SQL Server 2012 and SQL Server
2008.
Exult SQL Server 1.7
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.
Exult SQL Server 1.6
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.
Exult SQL Server 1.5
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).
Exult SQL Server 1.4
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.
Exult SQL Server 1.3
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.
Exult SQL Server 1.2
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.
Exult SQL Server 1.1
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.
Exult SQL Server 1.0
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.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel
(XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or
ACCDB), or CSV.
Shred and import XML into SQL Server.
Import XML data into automatically created MySQL
tables.