SQLite To PostgreSQL

SQLite is simpler operationally, but there are still a few important constraints to account for before you start.

Start here

• minimal-safe example
• recreate-fast example
• chunked-resume example

SQLite-specific realities

• worker count is always effectively 1
• source_snapshot_mode = "single_tx" is unsupported
• the source must be a real SQLite file, not an in-memory database
• the source is opened read-only
• MySQL-family-only and MSSQL-only type-mapping flags are rejected during config validation

Where SQLite is usually easier

• fewer source-specific type decisions
• no source schema selection
• fewer unsupported index shapes in typical workloads