PostgreSQL zero-downtime migrations made easy.
pgroll is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks.
Open-source database schema management tool. manage your database schema as code.
Atlas is a language-agnostic tool for managing and migrating database schemas using modern DevOps principles.
PostgreSQL foreign data wrapper for MySQL.
This PostgreSQL extension implements a Foreign Data Wrapper (FDW) for MySQL.
Tools for MySQL to PostgreSQL migration.
mysql_migrator is a plugin for db_migrator that uses mysql_fdw to migrate an MySQL or MariaDB database to PostgreSQL.
db_migrator is a PostgreSQL extension that provides functions for migrating databases from other data sources to PostgreSQL. This requires a foreign data wrapper for the data source you want to migrate.
Migrate to PostgreSQL in a single command!
pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today!