MySQL vs Ora2Pg
MySQL
mysql.com
Ora2Pg
ora2pg.darold.netSide by side
| Figure | MySQL | Ora2Pg |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 18 | 1 |
| Spec score · Data Migration Tools | 8.9 (#1) | 7.4 (#10) |
| Support | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. | Commercial migration planning, execution, and support are available through HexaCluster; users can report issues and contribute through the project repository or email. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
Ora2Pg
Ora2Pg is free, self-hosted software for assessing and migrating databases to PostgreSQL. It scans Oracle databases, extracts structures or data, and generates SQL; the site also lists MySQL as a source and mentions MariaDB and Microsoft SQL Server migration. Reports can estimate migration difficulty and cost. Exports include tables, views, indexes, constraints, functions, triggers, procedures, and packages, with basic automatic PL/SQL-to-PL/pgSQL conversion. Data can be exported completely or selected with a WHERE clause, including Oracle BLOBs as PostgreSQL BYTEA. Ora2Pg can generate Pentaho Data Integrator XML, send spatial geometries to PostGIS, and export DBLINK as Oracle FDW. By default it writes files for psql loading, while direct PostgreSQL import is available after configuring a connection. Oracle migrations require Perl 5.10 or later, DBI, and Oracle client libraries; other sources need their drivers and client dependencies. Generated Oracle-specific PL/SQL may require manual review and changes. The software is distributed under GPL version 3 or later.