create sqltables from xsd

[Droomgans]

Hi everybody,

I have some xml files, and a xsd file.
What's the best way to create tables on sqlserver conform my xsd
and get all the data from the xml-files into my sql-tables?

I don't want to create the tables manually, but use the xsd

here is also an example of the xsd and xml

thanks in advance

 

[Tom]

Create SQL table script from xml schema File (.xsd)

I think this link will answer your questions about creating tables from the schema file