MS SQL XML - XSD to SQL Server Tables

Author

XSD to SQL Server Tables

darren.pruitt@gmail.com

2005-12-14, 9:24 am

I have seen around the net lots of ways to turn a SQL Server database
into an XSD document. My question is: Is there a way to do the
oppisite?

I have an XSD file and I want to create a database from it. I also
have XSDObjectGen and have used it to create the domain objects for the
xsd. But now I have a requriement to store the data in relational
tables so I would like an automatic way to convert the XSD to tables.

Does anyone know of any stand alone app or any CodeSmith templeates
that will do this?

Thanks,

Darren

Michael Rys [MSFT]

2005-12-14, 8:25 pm

There is a schema gen option in the SQLXML XML Bulkload object that gives
you a rudimentary mechanism to generate the relational schema from an XSD
based on mapping annotations.

Best regards
Michael

<darren.pruitt@gmail.com> wrote in message
news:1134573605.223116.320400@g44g2000cwa.googlegroups.com...
>I have seen around the net lots of ways to turn a SQL Server database
> into an XSD document. My question is: Is there a way to do the
> oppisite?
>
> I have an XSD file and I want to create a database from it. I also
> have XSDObjectGen and have used it to create the domain objects for the
> xsd. But now I have a requriement to store the data in relational
> tables so I would like an automatic way to convert the XSD to tables.
>
> Does anyone know of any stand alone app or any CodeSmith templeates
> that will do this?
>
> Thanks,
>
> Darren
>

Sponsored Links