Page 1 of 1

Store XML file in SQL SERVER

Posted: Tue 27 Aug 2013 20:59
by smelchi
Hi
I have one (1) XML file for each order, with authentication and certificate information stored at XML ( size of 8 Kbyte ).

Which is the better way to load and store one XML Field in SQL SERVER using UNIDAC? I am using SQL EXPRESS R2 2008 and 2012.

I need to keep XML files for five years. I will need to retrive XML and save it to file.

Re: Store XML file in SQL SERVER

Posted: Wed 28 Aug 2013 08:38
by AlexP
Hello,

In UniDAC, XML fields are mapped as TMemoFields, therefore, to load and unload XML files, you can use the following TBlobField class methods:

Code: Select all

LoadFromFile
SaveToFile