SQL database from XMl,XSD files

8 Dec 2004 12:57 PM

Don Baechtel

How do you create a SQL database from XML/XSD files?

8 Dec 2004 5:18 PM

Michael Rys [MSFT]

You have to create the database yourself. You can use the SQLXML 3.0 XML
Bulkload facility to generate some basic table shapes based on an annotated
XSD using its schemagen option. However, that only gives you a first cut and
it is still recommended that you manually improve/refine your relational
schema.

There may also be third-party tools that provide such functionality.

Best regards
Michael

Show quote

"Don Baechtel" <dfpbaechtel2874@newsgroup.nospam> wrote in message
news:C84E7291-E29A-444C-B495-9C1951D6D411@microsoft.com...
> How do you create a SQL database from XML/XSD files?

8 Dec 2004 5:43 PM

Don Baechtel

You mean the the XSD designer in Visual Studio 2005 is just a graphical
drawing tool and can not be used to generate the database table structure
directly and that I have to construct the database design by hand ? Boy,
Microsoft is really droping the ball on this one. Surely Microsoft has
something in the works designed to remedy this situation. What about DSL?

Show quote

"Michael Rys [MSFT]" wrote:

> You have to create the database yourself. You can use the SQLXML 3.0 XML
> Bulkload facility to generate some basic table shapes based on an annotated
> XSD using its schemagen option. However, that only gives you a first cut and
> it is still recommended that you manually improve/refine your relational
> schema.
>
> There may also be third-party tools that provide such functionality.
>
> Best regards
> Michael
>
> "Don Baechtel" <dfpbaechtel2874@newsgroup.nospam> wrote in message
> news:C84E7291-E29A-444C-B495-9C1951D6D411@microsoft.com...
> > How do you create a SQL database from XML/XSD files?
>
>
>