Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raginbullsht
Starting Member
8 Posts |
 Posted - 2007-12-31 : 11:14:44
|
| Hello folks, I am going to try to explain this as best I can. First off I have a single database within SQL 2005 and the table within the database has a field for binary image data. Currently this database has about 4,000 image records.What I would like to do is recompress each of the images with new compression software called Déjà vu. What needs to happen in my mind is, pull the current binary data into the compression software, compress the image, then upload the binary data back into the same record as a batch command.My question is can I do something like that via command line? Or is this something that will require rebuilding the entire database from the ground up? I like having the data all in one database for ease of maintenance and intergration with other databases I am working with, so I dont want to just link the images. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-31 : 22:56:28
|
| You can dump data from db and update sql table in dos prompt with bcp and sqlcmd. |
 |
|
|
|
|
|
Binary images within a database