One config file
Use one TOML file to define source, target, hooks, validation, type mapping, and cutover behavior.
pgferry
Deterministic schema conversion, resumable COPY loads, and the operator controls you need when the source database is messy.
MySQL 5.7+SQLiteMSSQL 2017-2025PostgreSQL targetChunked COPYPlan before migrate
Why pgferry exists
Section titled “Why pgferry exists”Most migration tools are fine until the schema gets ugly: generated columns, unsupported indexes, collations, extension-backed types, or the first interruption halfway through a bulk copy. pgferry was built for that failure mode.
Preflight first
pgferry plan finds unsupported objects and generates hook skeletons before PostgreSQL is touched.
Resume when reality happens
Checkpointed chunking means long migrations can survive network failures and operator mistakes.
Modern edge cases included
PostGIS, citext, generated columns, source-specific type mapping, and bounded post-load parallelism are all first-class.
What you get
Section titled “What you get”Introspection that errs on the side of honesty
Source schema analysis reports unsupported types, generated columns, skipped indexes, views, routines, and triggers that need manual handling.
COPY performance with control
Chunked range planning for eligible tables, worker pools for the hot path, and bounded index creation during post-migration cleanup.
Operational escape hatches
Hooks at four phases, schema_only and data_only modes, orphan cleanup, snapshot options, and configurable defaults preservation.
Validation instead of vibes
Optional row-count checks and explicit logging reduce the number of surprises left for cutover day.
Default path through a migration
Section titled “Default path through a migration”pgferry plan migration.tomlpgferry migration.toml- Inspect the source and generate a preflight report.
- Fill in hooks for views, routines, or custom data cleanup.
- Run the migration with chunking, checkpoints, and optional validation.
- Review post-load objects, row counts, and extension-backed features before cutover.
Source matrix
Section titled “Source matrix”| Source | Driver | Workers | Snapshot mode |
|---|---|---|---|
| MySQL | go-sql-driver/mysql | Parallel | none, single_tx |
| SQLite | modernc.org/sqlite | Sequential | none |
| MSSQL | go-mssqldb | Parallel | none, single_tx |