Migration guide
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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.