Skip to content
TwinCommitDocs

twincommit verify

twincommit verify compares each source table with its replicated target table and reports differences. Use it after the first snapshot, periodically during a migration, and before cutover.

Usage

Section titled “Usage”
Terminal window
twincommit verify -config pipeline.yaml
twincommit verify -config pipeline.yaml -tables SALES.ORDERS

How it works

Section titled “How it works”

Each source table is copied into a scratch schema on the target and compared row by row with the replicated table. The scratch copy is dropped afterwards.

Example

Section titled “Example”
SALES.ORDERS          1,048,211 rows   match
SALES.ORDER_LINES     3,920,004 rows   match
BILLING.LEDGER          612,300 rows   2 differ, 0 missing, 0 extra