[2008] xml to sql

I set up a filemontoringtool in vb.net

I want to monitor for xml files

store the xml data in a database

then move the xml files somewhere else ( or delete them im not sure yet)



Ive got steps 1 and 3 down


My question is to insert xml in sql server 2005 do you need to

open the file
read in the variable
then move the variables over

or is there a way to just chunk the file directly into the database?


ive never had any projects inserting data into a database (and only a few reading)


thanks for any help you can give.

do you want the actual file in the database, or the contents of the file?

if you are looking to get the contents into a table or something, here's some stuff to lookup that will help:
sp_xml_preparedocument
FROM OPENXML (@idoc, '/nodes/node',1)
(specifically FROM OPENXML is what you should be looking for).

-tg

You can easily store files in the database, if that is the approach you want to take. The down side with that is it is less searchable.


Take a look at this thread for how to store files in a db. It shows how to do it for images, but you should be able to take that and run with it.
http://www.vbforums.com/showthread.php?t=469562