Re: Compression Tool

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Tibor
SQL Backup has a compression for backups, but now I see that I misundertsand
Gal.




"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in
message news:Oyeo0fs0JHA.3476@xxxxxxxxxxxxxxxxxxxxxxx
Uri,

What tool at red-gate did you think of? I didn't find anything there that
seem to help with blob compression, I probably just don't see which you
refer to...


Gal,

The only way I've seen would be if you are on 2005 or higher and can
adjust your code to call a CLR function which compresses the data before
storing it. I vaguely recall reading somewhere some article about this and
we can probably hunt it down with some collective search sills. But I'll
wait with this until I know if modifying your code is an option. I have
not seen any such transparent tool.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:ODimjWs0JHA.4272@xxxxxxxxxxxxxxxxxxxxxxx
Gal
Red Gate ?



"Gal" <Gal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67B67319-460B-4DD1-9B4A-4C0E564C38C3@xxxxxxxxxxxxxxxx
Is there a commpression tool (even third party tool) that knows to
compress
blobs?






.

Relevant Pages

  • Re: Compression Tool
    ... What tool at red-gate did you think of? ... I didn't find anything there that seem to help with blob ... compression, I probably just don't see which you refer to... ... article about this and we can probably hunt it down with some collective search sills. ...
    (microsoft.public.sqlserver.server)
  • Re: How to compress bmps in a table?
    ... IMO, if your db is c/s, compression on the server side is a bad idea. ... Dellapasqua's fzlib is really useful for client side blob compression, ...
    (borland.public.delphi.thirdpartytools.general)
  • 7-zip compression to a stream
    ... 7-zip compression to/from a stream. ... I'm currently using a proprietry ... compression library for blob compression in a database app but the much ...
    (borland.public.delphi.thirdpartytools.general)