It just parse the fetchXML file and creates SQL statements based on the input, just like we humans do when we manually convert fetchXML to SQL.

Upload_xml.php uploads and stores the file by usage of the $_FILES function in PHP. Convert_XML.php loads the XML-file (with use of simplexml_load_file) and parses the lines into a single MySQL-query.

I want to convert the database definition of an existing SQL database into an XML schema, so I can use the schema with some model-driven development tools to create a new distributed application ...

Takes about 20 seconds to convert a 250kb XML file into 5 different sets of DB insert statements. <BR><BR>I'm running on Linux using Xerces and Xalan and converting to an Oracle 9.0.1 DB.

This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.