Generating XSD Schemas from SQL Database

[mpappert]

Hi Everyone ...

Is there a tool that will allow me to connect to an SQL Server 2000 database and create an XSD file of it? Ive searched MSDN and found an XSD.exe utility that comes with the .NET Framework SDK but it only works on XSR, XSD and XML files ...

Its for a VB.NET project ...

TIA!
M.

 

[Thinker]

Try using For XML, AUTO, XMLDATA at the end of your Select
statements. The Schema will be included in the return. The
biggest problem with this is it isnt exactly the w3c xml schema
format. I would check the MS web site to see what the status is
of them integrating the w3c xml schema standard into 2000.

 

[mpappert]

Thanks Thinker!

If I use the M$ "implementation" of XML and use VB.NET, theoretically since they are both M$ then I shouldnt have any problems right?

M.

 

[Thinker]

That would be a relatively safe assumption, but still not guaranteed.
One thing I do believe. MS is seriously on the XML bandwagon,
and wants it to be received as an internation standard, not just
an MS one. They have been involved with 3 different XML schema
methods (that I have heard of anyway) and just want to be on
the inside track for whatever method is finally widely accepted.