Create SQL Tables From an XML Schema

[Guest]

Hello,

Does anyone know how to create a SQL table from an XML schema
programmatically? I have an xml dataset that needs to update the SQL
structure. I have no problem going from SQL to XML. But what if I want to
go the other way?

Thanks,

Dolph

 

[Francois Bonin [MVP]]

You can use SQLXML Bulkload to achieve that.
Check out this article:
http://msdn.microsoft.com/XML/Build...ll=/library/en-us/dnsql90/html/exchsqlxml.asp

HTH
Cois

 

[Andrew Conrad]

See the SchemaGen option for SqlXmlBulkLoad. This however requires the XSD
to be annotated with relational information.

In Sql Server 2005, SSIS will support creating tables from an XSD based on
the existing DataSet functionality:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c09e251f-f8df-46f0-
b4ac-fbe567277722&displaylang=en


Andrew Conrad
Microsoft Corp

 

[Guest]

Thanks. I was hoping that there was a way to create sql tables from using
ADO.Net. I know about the SQLXMLBulkLoad. I decided to write a generic
method to generate SQL statements by looping through the dataset. I needed
to create tables for other databases as well as SQL Server. i.e. MS Access,
Oracle. etc.

Thanks Again,

Dolph