Posted by David Portas on 12/29/05 17:01

billy wrote:

> Hello,
> I have an XML data feed that I would like to use to create tables in
> SQL Server. The xml data feed consists of a large amount of
> information that changes on a regualar basis. Is there a way to
> automatically create SQL Server tables using the data feed?
>
> Thanks
> Billy

In SQL Server 2005 you can use the XML datatype to store XML documents
in a column but I don't think that is what you are asking for.

Deriving a useful relational schema from an arbitrary XML document with
no other information to go on is potentially a very difficult task.
What is the information that changes on a regular basis and how does it
or should it map to tables in your database? Do you know the metadata
in advance or only at runtime? How will users or processes consume the
data if its structure isn't known at design time?

--
David Portas
SQL Server MVP
--

[Back to original message]