Skip to content
pgferry

SQLite Examples

SQLite migrations are operationally simpler, but the example set still covers the choices that matter.

Available examples

Section titled “Available examples”

SQLite constraints worth remembering

Section titled “SQLite constraints worth remembering”
  • one worker only
  • no single_tx snapshot mode
  • in-memory SQLite sources are rejected
  • source-specific type mapping knobs for MySQL and MSSQL are invalid
Section titled “Recommended baseline”

Use minimal-safe first, then add hooks or schema-only/data-only modes as needed for your cutover procedure.