Examples

Reach for the examples when you’d rather start from something that already works than from an abstract reference page.

Pick by situation

• First production-style rehearsal: MySQL minimal-safe, MariaDB minimal-safe, SQLite minimal-safe, MSSQL minimal-safe
• Fast disposable reloads: MySQL recreate-fast, SQLite recreate-fast, MSSQL recreate-fast
• Large or interruption-prone runs: MySQL chunked-resume, SQLite chunked-resume
• Controlled sequencing: schema-only and data-only patterns
• Hook-driven follow-up SQL: MySQL hooks, SQLite hooks

Browse by source

• MySQL examples
• MariaDB examples
• SQLite examples
• MSSQL examples

What each example page includes

• when to use it
• tradeoffs
• a copy-pasteable migration.toml
• SQL hook snippets where relevant
• the exact command to run
• a link back to the raw files in GitHub

Before you run an example

1. Replace the source and target DSNs with your real endpoints.
2. Run pgferry plan migration.toml first.
3. Read the matching guide for source-specific constraints.
4. Decide whether you want the safe path, the fast disposable path, or the resumable path before you start editing flags.

Raw example files

• examples/mysql
• examples/mariadb
• examples/sqlite
• examples/mssql