Apr 272011

What command line parameters does WinZip support?
Below is some information about the undocumented command line options for using the WinZip program module, winzip32.exe.

WinZip supports command line options to add and extract from files. Be sure to read the Notes section below for additional important information.

Adding Files
The command format is:

    winzip32 [-min] action [options] filename[.zip] files

-min specifies that WinZip should run minimized. If -min is specified, it must be the first command line parameter.

-a for add, -f for freshen, -u for update, and -m for move. You must specify one (and only one) of these actions. The actions correspond to the actions described in the section titled “Add dialog box options” in the online manual.

-r corresponds to the Include subfolders checkbox in the Add dialog and causes WinZip to add files from subfolders. Folder information is stored for files added from subfolders. If you add -p, WinZip will store folder information for all files added, not just for files from subfolders; the folder information will begin with the folder specified on the command line.

-ex, -en, -ef, -es, and -e0 determine the compression method: eXtra, Normal, Fast, Super fast, and no compression. The default is “Normal”. -hs includes hidden and system files. Use -sPassword to specify a case-sensitive password. The password can be enclosed in quotes, for example, -s”Secret Password”.

Specifies the name of the Zip file involved. Be sure to use the full filename (including the folder).

Is a list of one or more files, or the @ character followed by the filename containing a list of files to add, one filename per line. Wildcards (e.g. *.bak) are allowed.

Extracting Files
The command format is:

    winzip32 -e [options] filename[.zip] folder
where -e is required.
-o and -j stand for “Overwrite existing files without prompting” and “Junk pathnames”, respectively. Unless -j is specified, folder information is used. Use -sPassword to specify a case-sensitive password. The password can be enclosed in quotes, for example, -s”Secret Password”.

Specifies the name of the Zip file involved. Be sure to specify the full filename (including the folder).

Is the name of the folder to which the files are extracted. If the folder does not exist it is created.
VERY IMPORTANT: always specify complete filenames, including the full folder name and drive letter, for all file IDs.

To run WinZip in a minimized inactive icon use the “-min” option. When specified this option must be the first option.

Only operations involving the built-in zip and unzip are supported.

Enclose long filenames in quotes.

When using a list (“@”) file, no leading or trailing spaces should appear in file IDs in the list.

The action and each option must be separated by at least one space.

WinZip can be used to compress files with cc:Mail . Change the compress= line in the [cc:Mail] section of the appropriate WMAIL.INI files to specify the full path for WinZip followed by “-a %1 @%2”. For example, if WinZip is installed in your c:\winzip folder, specify
    compress=c:\winzip\winzip.exe -a %1 @%2

Jan 052010

If you are having connectivity problems specify the database name in the box that asks “Which SQL Server do you want to connect to?” For instance, Computername\SQLEXPRESS.

You can also use the command line ‘sqlcmd’ to access SQL Server Express.
It is a pain to use but it works. You can write your code in a text
file then import it using the sqlcmd command. You also have to end
your query with a new line and type the word ‘go’.

Example of query file named test.sql:
 use master;
 select name, crdate from sysdatabases where xtype='u' order by crdate desc;
Example of sqlcmd:
 sqlcmd -S %computername%\RLH -d play -i "test.sql" -o outfile.sql & notepad outfile.sql