Tip
Practical guides to moving data off old systems and into the cloud: step by step migrations, errors and how to fix them, legacy file formats, and SQL to dbt. Every guide is tested on real databases and cites the official documentation.
All · Migration guide · Tip · File rescue · SQL to dbt · Error fixed · Comparison
- TipNovember 17, 2026
pg_dump and pg_restore: The Commands That Matterpg_dump and pg_restore run for real: plain vs custom vs directory, schema-only, excluding tables, selective and parallel restore, owners and roles.
- TipNovember 10, 2026
What a Database Migration Actually CostsDatabase migration cost is transfer, migration service, the parallel run, target size and people time. Measure the inputs, then price them.
- TipNovember 3, 2026
Zero Downtime Database Migration with CDCCopy from a snapshot, stream changes with CDC, then cut over in seconds: stop writes, wait for lag 0, verify, reset sequences, keep a reverse stream.
- TipOctober 27, 2026
How to Validate Data After a MigrationCompare exact row counts, column aggregates and an order-independent checksum on both databases, then bucket by key range to find the rows that differ.
- TipOctober 4, 2026
Database Migration Checklist, with a TemplateA database migration checklist where every item is a query: row counts, encodings, triggers, sequences and checksums, plus a copyable template.