Post reply

How to compress files (any extension) in SQL Server 2005

  • June 27, 2007 at 12:51 pm

    #179459

    Hi,

    I was using the extended stored procedures to compress files in SQL 2000. Now I'm using SQL 2005 and this sp doesn't exist anymore.

    I need to compress files in SQL 2005, and I know that I need to use CLR code in order to get what I want.

    The files that I need to compress are bigger than 2 MG, and their extensions could be htm, xls, cvs, etc.

    Does anybody know about any free software (3rd party) that I can use in SQL Server 2005?

    Or any ideas how can I compress files in SQL 2005?

     

    I will really appreciate any help about it?

    Vicky

     

     

     

  • June 27, 2007 at 1:04 pm

    #715614

    You can always use xp_cmdshell to run a command line version of a compression program, I've used gzip in the past.  I'm sure there are a number of other ways though.

     

  • June 28, 2007 at 12:49 pm

    #715960

    its probably better for you to create a .net assembly which calls the compression program.

    to what format are you compressing into?

    Everything you can imagine is real.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply