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

  • Article ID: 111525
  • Updated: 09 Oct 2014

In order to install or upgrade an older version of SafeGuard LAN Crypt Administration to a new version, 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 Administration 3.90

SafeGuard LAN Crypt Administration 3.80

SafeGuard LAN Crypt Administration 3.61

Operating Systems supported
All supported operating systems
Microsoft Management Console 3.0

What to do

  1. Run the tool 'CreateTables.exe' to install or upgrade 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

ur... update database structure and repair referential integrity errors

v... verify referential integrity

  • 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