XdataExtract is a fully functional XML tool that allows Database administrator, programmers, and computer users to upload xml data in to a Microsoft SQL server database effortlessly.
The only requirements to successfully execute the XDataExtract application are as follows: 1. A valid and well formed XML document(s). 2. Access to a SQL Server (User Name and Password).
3. A Sql Server Account that has the ability to create and modify databases. If all three requirements are satisfied, the user can import an xml document(s) into the database by selecting the XML file(s) to upload followed by entering the required Sql Server information.
The required Sql server information is as follows:Server name - User name - User password. The application has the ability to connect to Sql server7, Sql Server 2000 and Sql Server 2005.
Making this application a must for programmers, that are not well versed in the creating DTS package and/or T-Sql commands. In addition, to uploading XML information into Sql Server, the application has the ability to create new tables and fields based on the elements contained within the XML document(s).
As the application parses the XML document(s) it created a listing of the elements contained within. The user then has the ability to either import all elements contained within the document or select specific elements to upload.