DTD->SQL

Hi guys : There has to be a tool out there somewhere for converting a well formed XML document to a robust relational schema (preferably MySQL), but I can't find one.

Basically, I want to auto generate tables with relationships from the structure of an XML document, and also auto generate tools for importing data from that document into the database afterwards.

Any ideas ?

Thanks ,
J

Anyone hear anything on this one?

Just so you get a reply, I'm going with "no"

This is very interesting.
I'm looking for the same information, if I won't find anything interesting I'll write something myself.
I'll let you know.
cheers

XML documents are trees, not tables. So I certainly wouldn't expect to find something which converts arbitrary XML documents into database tables. You would have to severely restrict the contents and structure of the document before you could do that.

So don't hold your breath waiting.

That's true, but both xml and databases contain data.
I'm dealing with a complex environment in which many systems are implied, migrations are frequent and integration has a great relevance.