How should I handle tables without a Primary Key?
Add a primary key on the source before migration if possible. Otherwise treat partial transfer interruptions as a full reload into a clean target table.
Design database transfers around verifiable invariants: read-only sources, explicit type rules, deferred indexes, and repeatable recovery tests.
WHERE pk > last_pk. Refuse in-place appends on PK-less tables.DECIMAL values as exact strings and hash NULL differently from empty strings.plan.json and report.html as shareable audit artifacts free of secrets.Add a primary key on the source before migration if possible. Otherwise treat partial transfer interruptions as a full reload into a clean target table.