DBConvert Streams vs Ora2Pg

DBConvert Streams combines a database IDE for exploration and SQL with migration and change-data-capture streaming. One-time Load migrations and ongoing CDC replication are supported; MySQL CDC uses binlog replication and PostgreSQL CDC uses logical replication. Connectors include MySQL, PostgreSQL, Snowflake, local files, S3-compatible storage, and federated queries. Embedded DuckDB lets federated SQL join databases and file or object-storage sources in one statement. Local-file workflows handle CSV, JSON, JSONL, and Parquet, with CSV, JSONL, and Parquet listed as target formats. The software runs as a Windows, macOS, or Linux desktop application, or as Docker on a server, VPS, bare metal, or cloud VM. CDC does not need Kafka, Zookeeper, or Kubernetes; NATS is bundled in the desktop app or Docker Compose stack. It also offers an AI assistant, read-only MCP operations, and more than 80 REST endpoints. The Free plan is free and includes an IDE, viewers, extensions, and federated queries across two sources. Its CDC trial lasts seven days from the first stream and covers up to three tables.

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.