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.

 All Forums
 Development Tools
 Other Development Tools
 Zip a file using Windows Compression commands

Author  Topic 

Trudye
Posting Yak Master

169 Posts

Posted - 2008-08-04 : 10:28:21
I was creating a script to zip a file using WinZip on my local PC, the DBA told me late Friday the server I will be using does not have WINZip (go figure). I understand Windows has Compression software that allows you to zip a file.

I searched this site and found no samples. I Googled it and found the following example.
COMPACT P:\data\TestFile.txt /C

But this does not zip the file it just changes the size of the file on disk. Is there a command that will zip my file, and will it put a *.zip extension on it?

Any suggestions?
Thank you,
Trudye

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-04 : 10:29:56
dup.... and back in the script library again..??
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108003

Em
Go to Top of Page
   

- Advertisement -