PostgreSQL Migrator 1.0 stable

Paris, Monday, September 7, 2026

After a year of beta, Dalibo announces PostgreSQL Migrator 1.0 stable.

PostgreSQL Migrator is a tool for converting and migrating databases to PostgreSQL. We aim to bring a strong breath of modernization to this strategic area for many teams. This release already supports Oracle and MySQL/MariaDB systems.

Do you want to modernize or free your data with PostgreSQL? PostgreSQL Migrator will surely be of interest to you!

Features

PostgreSQL Migrator 1.0 benefits from our recognized expertise within the community. Several features make it a companion of choice in your modernization projects:

• very simple installation,
• inspection optimized once and for all,
• effective navigation through the migration project,
• simple and tweakable TOML configuration,
• parsing and transpilation of every piece of code in your model,
• and high-performance data transfer.

For this 1.0 release, object inspection is complete. PostgreSQL Migrator 1.0 can convert and migrate roles, schemas, sequences, tables, indexes and constraints. For data, PostgreSQL Migrator can migrate scalar, JSON and LOB data and convert boolean columns.

An effective interface

This software is aimed at DBAs coming from other systems. Detecting and presenting incompatibilities and alternatives in PostgreSQL is a major step in considering a migration. PostgreSQL Migrator offers effective navigation through the database model, both of the source — Oracle or MySQL — and of the future model to be created in PostgreSQL.

The interface offers thematic or hierarchical navigation, a global search, tabs and the identification of migration blockers. Unlike legacy database software, PostgreSQL Migrator offers a clean and intelligent interface rather than a plethora of buttons and dialog boxes. Transfer is done using CLI.

High-performance migration

To achieve a very efficient copy, PostgreSQL Migrator performs transfers using COPY statements only. We are convinced that exports in text format with INSERT or using Foreign Data Wrappers will never be relevant for a migration project. The tool writes the input data of the COPY command as it is read from the source, even for LOBs and other large data.

Not only is memory usage stable below 500 MB, but PostgreSQL receives the data as early as possible. Our tests show an overall throughput 10 times higher than free alternatives like Ora2pg. No extension is required in the target PostgreSQL instance.

PostgreSQL Migrator precisely orchestrates the many object-creation and copy tasks to guarantee the consistency of the migration process and the optimal use of resources.

Stable and proven

Despite its youth, PostgreSQL Migrator offers excellent stability. The project has a demanding continuous integration and development methods that guarantee non-regression. We test PostgreSQL Migrator on real Open Source projects, not just on small training databases. PostgreSQL Migrator has already migrated production databases. The investment in quality is real and the first feedback is very conclusive.

Free and documented

PostgreSQL Migrator is written in Go and does not depend on Oracle’s proprietary libraries. Like all Dalibo Labs software, PostgreSQL Migrator is entirely under the PostgreSQL license. No fine print at the bottom of the page!

The project page offers a guide to install and try out the tool, the documentation for the configuration and the command line, the supported and planned features, and news about the developments.

Use, contribute

PostgreSQL Migrator 1.0 is only the first milestone on a long roadmap. Soon, PostgreSQL Migrator will migrate views, triggers and partitions; inspection and transpilation are already in place. Like PostgreSQL itself, PostgreSQL Migrator implements features brick by brick with a focus on maintainability, stability and quality.

Dalibo has long offered a commercial service to migrate your most complex databases from all competing DBMS. A long history of contributions illustrates this expertise: Ora2pg, data2pg, transqlate and now PostgreSQL Migrator.

Many migration tools are proprietary; Dalibo offers a generous contribution to the community.

To get started right now, follow the guide.