Subject:Generating Schema question Author:Sebastian Kruse Date:02 Sep 2004 06:07 AM
Hello,
when creating an xml-Schema from an xml file, Stylus Studio creates 5 Schema-files. (Besides they are not well-formed, but that is the smallest problem I got...)
My question now is: Is it possible to create just one Schema-file from my xml-file or will Stylus Studio always create more than one Schema-file?
Any help/advice would be very useful to me. :)
Thanks in advance,
Sebastian
P.S. I've been looking in the forum for topics which could help me, but I didn'd find anything. So please don't be mad at me, telling me things like "Search the forum stupid..." ;)
Subject:Generating Schema question Author:Sebastian Kruse Date:03 Sep 2004 08:12 AM
Hello Ivan,
I'm afraid that's not possible, because it contains company-data of which I'm not allowed to send to anyone outside of the company. :(
But here are some informations about the XML-File:
It has been created with the document wizard (ADO to XML, so it has been created from database tables of a MS SQL Database).
It consists of 1055 lines.
I don't know if this could be useful or not...if you need further information, please let me know. (Also, please let me know if the information given about the XML-File are relevant for you or not...) ;)
As you can see the document uses multiple namespace; because XML schema can have only one target namespace the algorithm has to create multiples XML Schemas.
The schemas seem to be correct and I was able to validate the xml document using MSXML, XalanJ, Xerces and XSV.
If you would like to have more control you could try to use SQL/XML (DB to XML data source).
Here what I did:
Using the following query
SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "RegionID",t.RegionID),
XMLELEMENT(name "RegionDescription",t.RegionDescription)
)
FROM Northwind.dbo.Region t