How to compress files in SQL 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to compress files in SQL 2005

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

What kind of files you need to compress?
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
quote:Originally posted by vramos 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

I believe you are asking about xp-makecab proce…
File copression xtended procedure still exists and MS using it in their replication scripts…it is in resource database but not visible to the user…
Check for command line zip utility ….
http://www.7-zip.org/
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

I believe the originator asked similar question before:<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22250>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22250</a> [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
]]>