Schema Comparison Examples

Compares database or table schemas using rs_subcmp .

Example 1

Compares all schemas between two databases using the config.cfg file:
rs_subcmp -f config.cfg
The configuration file contains the following:
PDS = PASE
RDS = R2ASE
PDB = pubs2
PTABLE = authors
RTABLE = authors
PUSER = sa
RUSER = sa
PPWD =
RPWD =
SCHEMAFLAG = 1

Example 2

Compares schema between two databases without a configuration file:
rs_subcmp -Spds -srds -Dpdb -drdb -Usa -usa -Psa_pwd
          -psa_pwd -x1

Example 3

Compares schema of two databases excluding index, trigger, and datatype:
rs_subcmp -Spds -srds -Dpdb -drdb -Usa -usa -Psa_pwd
          -psa_pwd -x1 -XitD

Example 4

Compares all table schemas and user schemas:
rs_subcmp -Spds -srds -Dpdb -drdb -Usa -usa -Psa_pwd
          -psa_pwd -x1 -X+TU
Parent topic: Schema Comparison