Automated way to convert XML files to SQL database

Question

We have a bunch of XML files  following a schema which is essentially a serialised database form    lt table1 gt      lt column1 gt value lt  column1 gt      lt column2 gt value lt  column2 gt   lt  table1 gt   lt table1 gt      lt column1 gt another value lt  column1 gt      lt column2 gt another value lt  column2 gt   lt  table1 gt        Is there a really easy way to turn that into an SQL database  Obviously I can manually construct the schema  identify all tables  fields etc  and then write a script to import it  I just wonder if there are any tools that could automate some or all of that process

User · Answer

There is a project on CodeProject that makes it simple to convert an XML file to SQL Script. It uses XSLT. You could probably modify it to generate the DDL too.

And See this question too : Generating SQL using XML and XSLT

User · Answer

For Mysql please see the LOAD XML SyntaxDocs   It should work without any additional XML transformation for the XML you ve provided  just specify the format and define the table inside the database firsthand with matching column names   LOAD XML LOCAL INFILE  table1 xml      INTO TABLE table1     ROWS IDENTIFIED BY   lt table1 gt      There is also a related question    How to import XMl file into MySQL database table using XML LOAD    function   For Postgresql I do not know

User · Answer

try this  http   www ehow com how 6613143 convert-xml-code-sql html  for downloading the tool  http   www xml-converter com

User · Answer

If there is XML file with 2 different tables then will    LOAD XML LOCAL INFILE  table1 xml  INTO TABLE table1  LOAD XML LOCAL INFILE  table1 xml  INTO TABLE table2   work

[mysql] Automated way to convert XML files to SQL database?

Examples related to mysql

Examples related to xml

Examples related to postgresql

Examples related to schema