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 |
|
JustinBigelow
SQL Gigolo
1157 Posts |
 Posted - 2004-08-10 : 13:44:07
|
Hi all,I'm back for some shameless exploitation of the community  . I'm working with an application that stores Rich Text Format resumes as blob data. According to the vendor that created this application the data is encoded in base 64 and compressed via gzip. Does anybody have an opinion as to what would be the best plan of attack for getting this data out of SQL Server using one of SQL Server tools (i.e. bypassing the original application's interface)?Thanks,Justin"Hit me with a shovel 'cause I can't believe I dug you." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-12 : 13:19:29
|
| Go to the cygwin site and download gzip (free). Think it has a command line interface you can use via xp_cmdshell.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Unzipping blob data