Generate XSD from SQL Server database in order to import XML data

Question

Is there a tool to generate an XSD schema from SQL Server database ?

This XSD would be used for importing XML data into database with BULK INSERT or bcp

Answer 1

I dont know any tool but you can do this with Sql Script.

check this link

http://www.simple-talk.com/sql/t-sql-programming/beginning-sql-server-2005-xml-programming/