DDL from XSD?

Apologize if this is a frequent question. Is there some tool that can read
an XSD and create a set of table definitions into which the corresponding
XML doc could be shredded?
Conceptually, like this:
XSD defines a parent-child relationship (cust-order); output from tool would
be 2 tables with a FK definition
Thanks, Steve
Hi Steve,
XMLSpy? 2007 Professional Edition can handle this request for you. Please
feel free to download and evaluate any of our products.
More details on this feature can be found here,
http://www.altova.com/features_database.html
Best regards,
... Jerry Sheehan
... Pre-Sales Engineer
... Altova, Inc.
"Steve Mc" wrote:

> Apologize if this is a frequent question. Is there some tool that can read
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool would
> be 2 tables with a FK definition
> Thanks, Steve
>
>
|||Look at the schema gen option on the SQLXML Bulkload object.
Best regards
Michael
"Steve Mc" <stevemc@.zillow.com> wrote in message
news:unEHSgQRHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Apologize if this is a frequent question. Is there some tool that can
> read an XSD and create a set of table definitions into which the
> corresponding XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool
> would be 2 tables with a FK definition
> Thanks, Steve
>
|||On Jan 31, 2:18 am, "Steve Mc" <stev...@.zillow.com> wrote:
> Apologize if this is a frequent question. Is there some tool that can read
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool would
> be 2 tables with a FK definition
> Thanks, Steve
XML Differencing: http://www.stylusstudio.com/xml_differencing.html
XML Differencing Tutorial: http://www.stylusstudio.com/videos/xmldiff1/
xmldiff1.html
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.com
|||Whoops sorry ignore that last post. Wrong thread. Sorry!!!