XML and SQL server (standards)

[ResolutionsNET]

Hi,

Can anyone point me in the correct direction. I have some large XML file that I wish to store in an SQL database.

What is the standard way to achieve this? Do I store the XML in one row. Or do I build a table to reflect the relationship of the XML????

Thanks

 

[otalens]

It depends. If the XML structure is one-on-one like the database tables, you can send it as one large string to SQLServer, but there are length limitations .
It is nicer to cut the XML string in logical parts and send that to the DB.

Good luck.

Regards,

Oliver Talens
*****************************
Abyss I.T. Solutions
Mathildastraat 36B
4901 HC Oosterhout

http://www.Abyss.nl

http://www.PanelPoint.nl

tel: +31 (0)162-439809
fax: +31 (0)162-439882
O.Talens@Abyss.nl
*****************************

 

[wujen]

Winter,

If you have SQL2000 server it has integrated XML capabilities. Your other post I reference you to couple of books.
The professional XML database from Wrox Press has a couple of chapters that deal with XML/SQL server issues.
Chapter 14 storing/retrieving xml in SQL server 2000
has the topic of
For XML
OPENXML
xml bulk load
etc

Chapter 15 xml views in SQL server 2000
that is almost self explainatory.

Plus wrox press has just released professional SQL 2000 server XML.
that would give you alot more information ..plus the other SQL 2000 books as well

Aaron