Administrative tasks from the command line

Library configuration & administration

You can perform the common maintenance tasks of exporting a SQL library to JET and/or compacting a JET library from the command line. This allows you to automate the process in a batch or as part of a scripted or scheduled process. You may choose to do this as part of your regular backup routine.

Note: To use the Author-it Administrator program from the command line, your user login must have the Security Administration permission.

Syntax

AITAdmin[.exe] libraryname [ /user /pwd ] [ /export ] [/excludelarge] [/compact] [/exit]

The parts of the command line switch syntax are:

Argument

Description

AITAdmin

The path to the Author-it Administration program.

libraryname

The type, name and path of your Author-it Library (.adl) file. Author-it will open this library when found.

For example:

/jet"C:\Program Files\Author-it\Data\Libraries\Acme.adl"

-or-

/sql"Acme|server1"

user

User account to sign in to the Author-it library database.

pwd

Password used to sign in to the Author-it library database.

export

Where the libraryname has been specified with the /sql parameter, instructs Author-it Administration to Export the SQL Server Library Database to a Jet Library Database.

You must supply the name of the new Jet Library, you do not have to supply the path to this file. To make sure that your relative paths remain valid, the file is created in the existing Library Path.

Note that if the export file already exists, it will be deleted.

Example:

/export"Backup.adl"

excludelarge

Automatically excludes object history, and locking information when exporting library.

compact

Where the libraryname has been specified with the /jet parameter, instructs Author-it Administration to Compact the Jet Library database.

Where the libraryname has been specified with the /sql parameter and with the /export parameter, the Jet Library created by the Export process will be compacted.

/exit

Tells Author-it to close and exit after the process is complete.

Examples:

To compact a Jet Library database:

c:\Program Files\Author-it\AITAdmin.exe /jet"c:\Program
Files\Author-it\Data\Libraries\Sample.adl" /user"(supervisor)"
/pwd"password" /compact

To Export a SQL Server Library database to Jet and compact the Jet database after exporting:

c:\Program Files\Author-it\AITAdmin.exe /sql"my database|my
server" /user"(supervisor)" /pwd"password" /export"New Jet
Library.adl" /compact