How to import XML files to SQL Server?

SUNNYVALE, USA: Novixys Software, Inc. has released Exult for SQL Server v. 1.1, an easy to use Windows application that helps database administrators  to import XML files into a Microsoft SQL Server database.

Exult for SQL Server shreds the XML data to normal (relational) data, automatically creating the tables and columns as dictated by your XML structure.

Exult can import XML files from web or FTP sources. This capability is particularly useful for importing various types of XML data feeds from across the web. Weather data, airline information, stock market fluctuations, shopping feeds, forex prices and many more XML feeds can be imported into SQL Server without a hassle.

It also helps to load a single XML file or load hundreds of XML files in one go and uses a smart merge technology to merge the data from multiple XML files while importing it into SQL Server.

A key part of the information in XML is the parent-child relationships expressed in XML. Exult for SQL Server automatically creates the appropriate database relationships while importing the XML so that the XML structure is mirrored.

Exult for SQL Server is specially optimized for loading data from large and complex XML files without running into memory or resource restrictions. Rest assured that you don't need to write a single line of code to accomplish all this. No more wrestling with XML style sheets too. Exult's Wizard interface does all the work, and extracts the data effortlessly. Power users can do batch conversions, using the command-line program to set up automated conversions.

Whether you're a database administrator who needs to quickly load XML files into SQL Server or a computer consultant who needs a powerful conversion application that doesn't take weeks to master, Exult for SQL Server is for you.

Exult for SQL Server v. 1.1 runs under Windows 2000/XP/2003/Vista, and supports Microsoft SQL Server 2000 or 2005.

Click here to download a free 14-day trial version of Exult.