How to create a SQL Server table schema from an XML schema? (with .NET and Visual Studio 2008)

Question

I have an XML schema, and I know that "xsd.exe" can generate C # code for it. But I want to know whether it is possible to automatically create MS SQL Server 2005+ tables from XSD using these or other tools.

BTW I was not able to get the C # code generated using "xsd.exe". What is the difference between the code generated by CodeXS and xsd.exe?

Answer 1

You can use the XSD2DB utility

This is an example xsd2db.exe -f true -l [Server name] -n [Database name] -s D: \ po.xsd -t sql

http://xsd2db.sourceforge.net/

Answer 2

: , , . T-SQL, , , :

http://weblogs.sqlteam.com/peterl/archive/2009/03/05/Extract-XML-structure-automatically.aspx

http://weblogs.sqlteam.com/peterl/archive/2009/06/04/Extract-XML-structure-automatically-part-2.aspx

Answer 3

, # "xsd.exe", .

, : " , "

Microsoft .NET. XmlSerializer (typeof (GeneratedType)), Serialize() Deserialze() , / Xml .

, CodeXS, , : GeneratedType.FromXML(Stream/String) myGeneratedType.Xml .

, XML, , . - XML (.. XML DOM), XML, . :)

Answer 4

XML-, , .