• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DTD->SQL

 
jay vas
Ranch Hand
Posts: 407
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
jay vas
Ranch Hand
Posts: 407
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anyone hear anything on this one?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33674
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just so you get a reply, I'm going with "no"
 
gianni ipez
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Clapham
Sheriff
Pie
Posts: 20166
24
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
gianni ipez
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic