Database migration guides
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
- File rescueNovember 18, 2026
ACCDB vs MDB: Which Access Format You HaveACCDB is the Access 2007+ format, MDB the older one. Byte 0x14 of the file header tells Jet 3, Jet 4 and ACE apart; mdb-ver reads it for you.
- 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.
- Migration guideNovember 16, 2026
Access Database to SQL Server: Tables, Queries, FormsMove Access tables to SQL Server with SSMA, link them back so forms keep working, and rewrite Access SQL (#dates#, *, &, Nz) by hand.
- ComparisonNovember 15, 2026
MySQL vs PostgreSQL as a Migration TargetMySQL vs PostgreSQL for migrated data, tested side by side: collations, bad data, DDL rollback, CHECK, JSON, identifier case and a timed load.
- Error fixedNovember 14, 2026
mysqldump Error 2013: Lost Connection During QueryWhy mysqldump fails with error 2013 halfway through a table, reproduced on MySQL 8.4, and the fixes: timeouts, dumping to a file, and finding killers.
- SQL to dbtNovember 13, 2026
dbt Incremental: Merge vs Delete+InsertOn Postgres, dbt merge updates rows in place, delete+insert deletes and re-inserts them, append duplicates them. None removes rows deleted in the source.
- Migration guideNovember 12, 2026
On-Prem PostgreSQL to Amazon RDS: Checks, Dump, RestoreMigrate Postgres to AWS RDS: check extensions, roles and superuser-only objects, then pg_dump and pg_restore --no-owner as the master user.
- File rescueNovember 11, 2026
Open an ACCDB or MDB File Without Microsoft AccessOpen an ACCDB or MDB file without Access: Excel's From Access import on Windows, mdbtools on Mac and Linux, or a free Access to Excel converter.
- 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.
- Migration guideNovember 9, 2026
SQLite to PostgreSQL: .dump, a Converter and pgloaderSQLite to PostgreSQL, run for real: the errors .dump gives, mixed date types, text in INTEGER columns, identity and setval, and pgloader's defaults.
- ComparisonNovember 8, 2026
Snowflake vs Redshift vs BigQuery for Migrated DataSnowflake vs BigQuery vs Redshift for migrated data: billing by time or bytes, loading, decimal and JSON types, and real sqlglot output.
- Error fixedNovember 7, 2026
ORA-01722: invalid number, During a MigrationORA-01722 means a string failed to convert to NUMBER. Find bad rows with VALIDATE_CONVERSION, then convert explicitly with a format and NLS setting.
- SQL to dbtNovember 6, 2026
dbt Incremental Models, Shown with Real RunsHow dbt incremental models work, run by run on Postgres: is_incremental(), {{ this }}, unique_key, late rows and lookback, --full-refresh, on_schema_change.
- Migration guideNovember 5, 2026
SQL Server to PostgreSQL: Types, Code and ToolsSQL Server to PostgreSQL type mapping (money, bit, datetimeoffset, rowversion, collation), T-SQL run through sqlglot with hand fixes, and AWS SCT and Babelfish.
- File rescueNovember 4, 2026
DBF to CSV, with Python and WithoutConvert DBF to CSV in Python with dbfread and the csv module, or without code. Deleted rows, code pages, memo files and the CSV's BOM, all tested.
- 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.
- Migration guideNovember 2, 2026
Oracle to PostgreSQL with ora2pg: the workflow and the trapsInstall ora2pg, run SHOW_REPORT, export tables, data and PL/SQL in order, then fix what it cannot: DATE, NUMBER, empty strings, DECODE, ROWNUM.
- ComparisonNovember 1, 2026
Azure SQL Database vs Managed Instance vs SQL Server on a VMSQL Database drops instance features, Managed Instance keeps nearly all except file-system ones, a VM is full SQL Server you patch. A checker shows which fits.
- Error fixedOctober 31, 2026
invalid byte sequence for encoding "UTF8": 0xa0, 0x92, 0xffThe file is Windows-1252, Latin-1 or UTF-16, not UTF-8. Load it with COPY ... ENCODING 'WIN1252', or convert it first with iconv -f CP1252 -t UTF-8.
- SQL to dbtOctober 30, 2026
SQL to dbt: One Query Becomes One ModelConvert a SQL query to a dbt model: sources, CTEs, ref(), a var for now(), tests, and an EXCEPT check proving the same rows come back.
- Migration guideOctober 29, 2026
MySQL to PostgreSQL Migration, Step by StepA MySQL to PostgreSQL migration run for real: mysqldump, the errors a raw dump gives, hand-written DDL, zero dates, setval and row-count checks.
- File rescueOctober 28, 2026
DBF to Excel Without Losing Dates or Leading ZerosConvert DBF straight to .xlsx, not via CSV: text columns keep leading zeros and D fields stay real dates. Tested with pandas, CSV and our converter.
- 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.
- Migration guideOctober 26, 2026
SQL Server to Azure SQL Database, Step by StepFind what Azure SQL Database will not run (cross-database queries, Agent, CLR, FILESTREAM), then move with BACPAC, DMS or replication.
- ComparisonOctober 20, 2026
Aurora vs RDS: Which One to Migrate ToAurora vs RDS: shared three-AZ storage, faster failover and per-I/O billing against the stock engine. How to measure your I/O and pick.
- Error fixedOctober 16, 2026
invalid byte sequence for encoding "UTF8": 0x00PostgreSQL text columns cannot hold a NUL byte. Strip 0x00 with tr or REPLACE(col, CHAR(0), '') before loading, or use bytea for binary data.
- SQL to dbtOctober 12, 2026
Convert a Stored Procedure to dbt ModelsTurn each INSERT, UPDATE, DELETE and MERGE in a stored procedure into a dbt SELECT, then prove parity with EXCEPT. Shown on a real PL/pgSQL run.
- Migration guideOctober 9, 2026
PostgreSQL to Snowflake: Type Mapping and ReplicationPostgres to Snowflake type mapping (numeric, timestamptz, jsonb, arrays, uuid, bytea), the replication connectors, and a COPY export that loads cleanly.
- File rescueOctober 7, 2026
How to Open a DBF File on Windows 11 and MacOn Windows 11, Excel opens dBase III and IV .dbf files but cannot save them. On a Mac, use Python's dbfread or a free DBF to Excel converter.
- 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.
- Migration guideOctober 1, 2026
MySQL to Aurora: Moving from RDS or Your Own ServerRDS MySQL to Aurora: use an Aurora read replica or a snapshot. From your own server: mysqldump or XtraBackup via S3. Convert MyISAM first.