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

You can use SQLXML Bulkload to achieve that.
Check out this article:
http://msdn.microsoft.com/XML/Buildi...exchsqlxml.asp

HTH
Cois
"Dolph Larson" <(E-Mail Removed)> wrote in message
news:F3A9C289-559F-4E5F-B968-(E-Mail Removed)...
> 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

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/d...51f-f8df-46f0-
b4ac-fbe567277722&displaylang=en


Andrew Conrad
Microsoft Corp

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

""Andrew Conrad"" wrote:

> 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/d...51f-f8df-46f0-
> b4ac-fbe567277722&displaylang=en
>
>
> Andrew Conrad
> Microsoft Corp
>
>