I have a table containing a field with binary data,
Field is Gzip format and if unziped the content is XML.
I need to read this field,
unzip the XML data,
edit the XML data
Save the edited XML back to Gzip
Save the Gzip data back to the binary field
The update needs to be done on more than 1000 records
The database is not part of any reporting services
Have you seen any good examples doing this?
Looking for a example to get me going.