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
 Other Forums
 Other Topics
 Zip a file using Windows Compression commands

Author  Topic 

Trudye
Posting Yak Master

169 Posts

Posted - 2008-08-04 : 13:18:38
Hi guys, not sure what’s going on, but I posted this question twice in the ‘Script Library’ forum and it was bounced both times. Consequently I have no idea where to post this, I’ll try here.

I was trying to create a script on my local PC using WinZip, when the DBA informed me the server I will be using does not have WinZip loaded (go figure).

Someone said Windows has a Compression command. I Googled Windows Compress and followed their example but the file did not Zip.
COMPACT P:\data\TestFile.txt /C
It compresses the file on the disk but the file does not zip it (eg. If you ck Properties on the file it shows size: 183 kb/ Disk size 68 kb).

I tried to find the executable for the zip command found in ‘Send To’ on the shortcut menu but could not find one.

Any suggestions?

OBTW, I do not have rights to load any software on the Server.

Thank you,
Trudye

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-04 : 13:24:46
it didn't bounce. i moved both of it.

you can find your original hopefully answered post here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108003

for the future: the script library is used to post only fully already working scripts.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

Trudye
Posting Yak Master

169 Posts

Posted - 2008-08-05 : 07:58:42
Thanx for the feedback, I was worried.
Go to Top of Page
   

- Advertisement -