Converting XSD to Oracle DDL

[Padma R]

What are the best tools for doing this? what are their strengths and weaknesses if we were working on a large project?

[tamilselvan]

What is XSD?

Tamil

[davey23uk]

xml schema definition

http://www.google.com/search?&q=xsd

[hobbes]

It is easy to generate XSD from an Oracle table [DBMS_XMLSCHEMA.generateSchema], but the reverse is not as straight-forward. You might want to check out Altove XmlSpy 2006 ; it has the capability to create relational DB schemas from XSD. There is also XMLFox, though cannot vouch for it not having used it myself.

As this conversion would likely be a one-time activity, as long as the tool gives you accurate results you should be fine with any?

Not sure of your business requirements but while designing your system I hope you have given thought to storing the XML data as-is in the database, as opposed to changing it to relational form.

Here's a discussion that sheds light on the pros and cons of both approaches:
http://asktom.oracle.com/pls/ask/f?p...:2957707652801,

[Padma R]

We were taking a look at XMLSpy. Maywe we should see the freeware too.