generate schemas for sql 2008 xml bulk load

Question

hey guys i have to import large sized xml data files (some of them 500 mb in size) into sql 2008. i plan to use sqlxml bulk load for the same.

however i am only interested in certain elements of the xml data file, not each and every element. my question is: in the schema file do i need to mention each and every element present in the xml data file or only those elements which i am interested in loading

second question is: is there any tool by which i can automate the generation of these schema files for sqlxml bulk load as i have very little knowledge of xsd / xdr

thanks in advance

Answer 1

You can use XSD.exe to create the schema from the XML data file.