How to use the tool 'CreateTables.exe' to install or upgrade the SafeGuard LAN Crypt database

  • Article ID: 111525
  • Updated: 05 Feb 2013
In order to install or upgrade an older version of SafeGuard LAN Crypt Administration to version 3.61, use the command line tool CreateTables.exe to adjust the structure of the tables in your SafeGuard LAN Crypt database. The tool is available in the \Install directory of your installation CD. (The installation CD is obtainable as a zipped CD image via MyUtimaco.)

Known to apply to the following Sophos product(s) and version(s)
SafeGuard LAN Crypt Administation 3.61

Operating Systems supported
Windows XP SP2/SP3
Windows Vista (Ultimate / Enterprise / Business) SP1
Windows 7 (Ultimate / Enterprise / Professional)
Windows Server 2003 R2
Microsoft Management Console 3.0

What to do

  1. Install SafeGuard LAN Crypt Administration 3.61
  2. Run the tool 'CreateTables.exe' to install or ugrade the SafeGuard LAN Crypt database. Please see the examples below.

Command line syntax:
CreateTables <ODBCName[.creatorname]> <SQL dialect > <action>

SQL dialect:
m ... Microsoft SQL Server

o8... Oracle 8

o... Oracle 9 or higher
ODBCname:
The name used for the ODBC data source.

Creatorname:
For the database to be addressed correctly, the database creator must be specified in CAPITALS for Oracle databases.

Actions:
a….all (drop and create all tables)

d.... drop all tables

dc... drop all constraints

c..... create all tables

cc... (re)create all constraints

ct.... (re)create all triggers

e..... empty all tables

l...... add logging tables

t...... add timestamp columns and triggers

u..... update database structure
  • Use the parameter o9 for Oracle 10/11 databases.
  • For Oracle a database owner should always be specified

Example 1 - Create a new SafeGuard LAN Crypt database using Microsoft SQL Server:
CreateTables SGLCSQLServer m c

Example 2 - Create a new SafeGuard LAN Crypt database using Oracle:
CreateTables SGLCSQLServer.SGLC o9 c

Example 3 - Upgrade an existing database using Microsoft SQL Server:
CreateTables SGLCSQLServer m u

Example 4 - Upgrade an existing database using Oracle:
CreateTables SGLCSQLServer.SGLC o9 u

 
If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent

Comments