psTranslateSchema

Description

     This program reads a Sybase schema and writes the DDL scripts
to create the schema in a different database.   For example, it can
translate a Sybase schema to an Oracle schema.

Syntax

psTranslateSchema -Sserver -Uusername -Ppassword -Ddatabase -Ttime_out
-Wowner -Nname
-Ltarget_ddl_file -Etarget_ddl_section -Ydatatypes_file
-starget_schema_name -wtarget_owner -ptarget_stored_procedure_prefix
-dtarget_directory_for_sql_scripts -Flog_file -Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User Password

-D

Sybase Database

-W

List tables belonging to owner only

-N

List tables having pattern 'name' [%]

-T

Time out in seconds [3600]

-L

Target DDL File [/disk2/ceccareb/PS/dbaccess/parameters/ddl.conf]

-E

Target DDL Section [Oracle 9i]

-Y

Datatypes File [/disk2/ceccareb/PS/dbaccess/parameters/datatypes.txt]

-d

Directory Where SQL Scripts Go [.]

-s

Target Schema Name [schema] (documentation purposes only)

-w

Target Object Owner [ defaults to original object owner ]

-p

Target Stored Procedures Prefix [PS_]

-F

Name of output table list file [standard output]

-O

Options

u

Make all object names upper case

l

Make all object names lower case

w

Ignore reserved words

g

Generate check constraint names

a

Write all scripts

c

Write rules (check constraints)

r

Write RI constraints

p

Write stored procedures

C

Add check constraints

R

Add referential integrity constraints

h

Write check rules

i

Write check RI

d

Write drop rules

e

Write drop RI

D

Write drop all objects

y

Write delete rule violators

z

Write delete RI violators

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

SYB_DATABASE

When -D is not specified

PS_SYSMSG_FILE

Name of the tool's messages file