Shift physical images from Database to local Disk

Adalat Khan

Dear All,

We have database in which we stored physical images which occupied more database space. Now we want to transfer the stored images from database and store them physicaly on local computer Hard Disk and only the name of these images are stored in the database.

Is there any way to transfer the stored images from Database table to local Disk????. Please cooperate in this regards.

Thanks & Regards.

Adalat Khan

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh6y ago
Accepted answer
Hi you can convert your stored image into physical image and then save it.
https://www.codeproject.com/Articles/33310/C-Save-and-Load-Image-from-Database
https://www.c-sharpcorner.com/UploadFile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/
https://stackoverflow.com/questions/18640494/how-to-construct-an-image-from-varbinarymax-change-its-type-and-store-to-a-ph
+2
Amit Gupta6y ago
1. Create a new column for storing the image filename. 2. Fetch the image column's data (bytes[]) and write it on a local drive with a filename and use the same filename to write back onto your newly created column. (This will help you to identify that you had written the image). 3. After all verification done then you can delete the image column.
+2
Adalat Khan6y ago
If you give me some hints it will be highly appreciated.
+1
Amit Gupta6y ago
You have to create your logic to build a tool for this scenario.
+1