Tools to create .xsd and sql schema from .xml file
Posted on 2003-12-02
I am trying to use SqlXML 3.0 SP2 to "Bulk Upload" an XML Document directly to my sql database.
I, however, have the following questions:
1. Given an .xml file, how do I generate an .xsd for it? I have explored using the Microsoft XSD Inference Tool "infer.exe" and using the XML Schema Definition Tool (Xsd.exe from VS.Net 2003). Both produce .xsd files, but do not seem to encapsulate relationships (e.g., sql:relation= or sql:relationship=) between the elements.
2. Given an .xsd file, are there any tools to create a sql schema from the .xsd file?
I am primarily interested in Microsoft tools for the above.