Schema Comparison

Schema comparison is useful in comparing schema between two databases that may have the same data but different schemas.

For example, if you want to compare all schemas between two databases using the config.cfg file:

rs_subcmp -f config.cfg

A report file which details the comparison result between two tables or two databases is created after every schema comparison. The report file is named reportPROCID.txt. If inconsistencies exist, rs_subcmp creates a reconciliation script named reconcilePROCID.sql. The report file and the reconciliation script are saved in the same directory where you issued the rs_subcmp.

Note: Before running rs_subcmp for schema comparison, make sure that ddlgen is working on your environment.

See Replication Server Reference Manual > Executable Programs > rs_subcmp.