*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!

[PostgreSQL Migrator]: https://postgresql-migrator.readthedocs.io/
[transqlate]: https://gitlab.com/dalibo/transqlate/
[implemented and planned features]: 
https://postgresql-migrator.readthedocs.io/en/latest/references/features/

Reply via email to