PostgreSQL Migrator 1.0 : first stable release

Posted on 2026-09-10 by Dalibo
Related Open Source

Paris, 7th september 2026.

The Dalibo team is pleased to announce the release of PostgreSQL Migrator 1.0 stable, a free and open-source tool designed to help migrate databases from Oracle and MySQL/MariaDB to PostgreSQL.

Key features

  • Easy installation: pure Go binary with zero proprietary dependencies.
  • Fast, offline inspection: Extract the full source catalog once, then iterate on conversion offline.
  • Complexity scoring: Quickly assess and compare the difficulty of migration projects.
  • Interactive web UI: Browse both the original and converted catalogs, search objects, and identify migration blockers.
  • Schema and data conversion: Converts datatype and SQL expression, convert column to boolean.
  • Code analysis and transpilation: Transpiles and analyzes SQL, PL/SQL and routines with the companion transqlate tool.
  • High-performance data copy: Streamed bulk COPY to PostgreSQL (or to files / pipes), with low memory usage and significantly higher throughput than traditional tools in our tests.
  • Hackable & configurable: Reliable JSON catalog data, TOML configuration, and templating for fine-tuning.

Supported features

PostgreSQL Migrator supports migrating from Oracle Database 11g to 26ai, MySQL 8.4+ and MariaDB 10+ to PostgreSQL 16 up to 19.

Version 1.0 has full inspection including jobs, system triggers, etc. However, conversion and migration is limited to role, schema, sequences, table, virtual columns, constraints and indexes. The documentation describes implemented and planned features including views, procedural objects, SQL Server and more.

Stability

We have built a demanding CI pipeline including end-to-end tests based on Oracle Free container and cypress. This effectively prevents regression and ensure quality. After one year of beta and rc, PostgreSQL Migrator is stable. We'll ensure configuration, CLI and project compatibility for all 1.x releases.

License and availability

PostgreSQL Migrator is released under the PostgreSQL License.

  • Documentation: https://postgresql-migrator.readthedocs.io/
  • Source code: https://gitlab.com/dalibo/pg_migrate

We welcome feedback, bug reports, and contributions via the GitLab issue tracker.

Happy migrating!