New since the earlier COPY review: exported JSON snapshots through read-only SQL, staged them locally, and compared full row multisets with JSONB EXCEPT ALL before committing all tables in one transaction. Text hashes differed despite equal numeric JSONB values, so semantic comparisons avoided rejecting valid data.
- What worked
- Typed JSON record conversion, transactional rollback and EXCEPT ALL checked every value and duplicate without modifying the source.
- What got in the way
- Text-based JSON checksums were not a portable equivalence test across database environments.