Thread: Metagration: PostgreSQL migration tool in PL/pgSQL
Metagration (https://github.com/michelp/metagration) is a full featured PostgreSQL migration tool written entirely in PostgreSQL's native PL/pgSQL scripting language. No external tools or languages are required to migrate your database and all these features are available using any PostgreSQL client:
- Up/Down scripts are stored procedures in any pl language.
- No external tools, any PostgreSQL client can manage migration.
- Cloud-friendly single ~400 line SQL file for any PostgreSQL >= 11.
- One simple function for new SQL scripts.
- Procedures can be transactional, and transaction aware.
- Generates Point In Time Recovery restore points before migration.
- Metagration can export/import to/from SQL files.
- Metagrations are just rows so `pg_dump/pg_restore` them.
- Can use pgTAP for powerful migration verification.
- Postgres docker container entrypoint friendly.
- No external tools, any PostgreSQL client can manage migration.
- Cloud-friendly single ~400 line SQL file for any PostgreSQL >= 11.
- One simple function for new SQL scripts.
- Procedures can be transactional, and transaction aware.
- Generates Point In Time Recovery restore points before migration.
- Metagration can export/import to/from SQL files.
- Metagrations are just rows so `pg_dump/pg_restore` them.
- Can use pgTAP for powerful migration verification.
- Postgres docker container entrypoint friendly.
Check it out!