mpappert Posted November 12, 2002 Posted November 12, 2002 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? I've 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 ... It's for a VB.NET project ... TIA! M. Quote
*Gurus* Thinker Posted November 19, 2002 *Gurus* Posted November 19, 2002 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 isn't 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. Quote Posting Guidelines
mpappert Posted November 19, 2002 Author Posted November 19, 2002 Thanks Thinker! If I use the M$ "implementation" of XML and use VB.NET, theoretically since they are both M$ then I shouldn't have any problems right? M. Quote
*Gurus* Thinker Posted November 19, 2002 *Gurus* Posted November 19, 2002 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. Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.