How to generate XSD of large XML file

Question

SQLXMLBulkLoad needs xsd schema to load data to SQL Server. How do I generate xsd schema of 1 Gb xml file? I tried to use xsd.exe, but it seems to load xml file into the memory first - I get OutOfMemory error

PS: I use C# for my app

Answer 1

Anyone?

Answer 2

I could do it on a 8GB+ file with trang and jing at

http://code.google.com/p/jing-trang/downloads/list

trang needs jing and java

just dump the jing stuff in the trang directory and put the xml-file there too for ease of use

cmdline:

java -jar trang.jar <file-to_xsd>.xml <xsd-name>.xsd

Cheers

Answer 3

Thanks for replying! But I'm not able to use Java

Answer 4

Can you get hold of a smaller version of the file?

Answer 5

Can you get hold of a smaller version of the file?

I can't get it from the source, but, probably, I can take first 3-5 Mb of XML file to create schema

Answer 6

check out this link for the solution.

http://docs.oracle.com/cd/E21043_01/integrate.1111/e12644/xml_file.htm