[2008] xml to sql

[Crash893]

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.

[techgnome]

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

[Negative0]

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