Store XML file in SQL SERVER

[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.

[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