xml dtd -> sql schema

Question

I've got xml document and XML's DTD.

Is there any tool that makes possible to:

create full sql schema from DTD.
convert XML doc with data into SQL.

No such tool, as XML is too free flowing to allow translation to SQL. — Oded, Oct 29 '11 at 20:11

score 1 · Answer 1 · edited May 23 '17 at 12:16

1

Use the following tools:

1) create full sql schema from DTD.

DTDParse + XML::RDB

2) convert XML doc with data into SQL.

Transform XML using XSLT to SQL

References

edited May 23 '17 at 12:16

Community

1
1

answered May 22 '14 at 02:13

Paul Sweatte

24,148
7
127
265

score 1 · Answer 2 · edited May 23 '17 at 12:16

DTD is a deprecated technology. You'll need to convert it to XSD to have any real hope of achieving this. W3 has A Conversion Tool from DTD to XML Schema which might help.

I'm thinking that you may be able to use the Codeplex project mentioned in the ADO.Net Entity Framework generate model from XSD file question to generate an Entity Framework model, retarget the model to a database and then generate schema from that.

Bear in mind, that I have not tried this myself. It just seems a likely path. I hope this helps. Good luck.

xml dtd -> sql schema

2 Answers2