Installation manual

Section 11 F Transferring Non -ENVOX Databases

112

Installing and Upgrading ENVOX

Configuration Software on DEC VAX and DEC AXP Systems (Revision B — May 1998)

Check Unsupported types in syscolumns

Message Fatal - Unsupported datatypes in syscolumns

Reason Supported types are: int, smallint, tinyint, binary, varbinary, char, varchar,

datetime, float

Check Unsupported types in systypes

Message Fatal - Unsupported datatypes in systypes

Reason Supported types are: int, smallint, tinyint, binary, varbinary, char, varchar,

datetime, float. (same as for syscolumns)

Check Check that columns u sing system datatypes use only legal ones

Message Fatal - Unsupported system defined datatypes in

syscolumns

Reason Legal ones are: binary, char, datetime, float, int, smallint, tinyint,

varbinary, varchar

Check Command permissions

Message Warning - Non public command GRANTS/REVOKES will not

be transferred

Check Foreign and common keys.

Message Warning - Foreign and common keys will not be

transferred

Check Keys on views

Message Warning - Keys on views will not be transferred

Check Numbered stored procedures

Message Warning - Numbered stored procedures will not be

transferred