Tuesday, March 27, 2012

excel export binary data?

hi

i used to export my tables to excel file

but now i have tables which have binary (image) data

what happens to them?

is there any way to backup these data?

Hi,

IMHO it is always a bad idea to store image data in a database, as databases are not meant to store BLOBs. It's possible, of course, in which case you can backup the data by backing up your database, but if I were you, I'd store the data on a fileshare, and only store a link to the location of the image in the database.

HTH.

Peter

No comments:

Post a Comment