0

I have a huge XML feed which has loads of entries. I need to create a database out of this XML feed such that individual tables are autogenerated and the linkages managed and the tables populated accordingly.

The XML file is quite extensive and each child has its set of child nodes and each node has its set of attributes. Is there an open source tool that does this or would I have to define a script i.e in php to do the work here?

Ali
  • 7,191
  • 20
  • 100
  • 158
  • your best bet is to extract an xsd and then read: http://stackoverflow.com/questions/403420/convert-xsd-into-sql-relational-tables – Didier Caron Sep 22 '11 at 20:28
  • Commercial tool like Enterprise Elements Repository. Not a simple job. Also investigate eCore – Randy Sep 22 '11 at 20:43
  • @DidierCaron - How can I extract an xsd – Ali Sep 22 '11 at 20:57
  • You could use Visual Studio or an specific tool, there are plenty if you google it. checkout http://www.dotkam.com/2008/05/28/generate-xsd-from-xml/ for a howto. GL – Didier Caron Sep 24 '11 at 05:09

0 Answers0