Friday, February 17, 2012

Creating DDL's from XSD

Hi,

I need to create DDL's( or Tables) from XSD.

Does SQL SERVER 2005 provides any facility for it.

If yes, then how it can be done.

Thanks

Manish

Take a look at the SchemaGen option on the SQLXML XML Bulkload object. Note that the generated DDL statements are making certain datatype assumptions per default that may need to be altered manually or use sql:datatype annotations.

Best regards

Michael

No comments:

Post a Comment