Amazon Database Migration Service vs Ora2Pg
Amazon Database Migration Service
aws.amazon.comOra2Pg
ora2pg.darold.netSide by side
| Figure | Amazon Database Migration Service | Ora2Pg |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | — | Yes |
| Plans published | 4 | 1 |
| Spec score · Cloud Migration Tools | 8.7 (#2) | 7.5 (#17) |
| Spec score · Data Migration Tools | 8.8 (#2) | 7.4 (#10) |
| Purpose | AWS DMS migrates relational databases, data warehouses, NoSQL databases, and other data stores to AWS or between cloud and on-premises setups. | Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL. |
Plans
Amazon Database Migration Service
- AWS Free TierFree
- AWS DMS ServerlessPriced on request
- Database Savings PlansPrice not published
- On-demand instancesPriced on request
In their own words
Amazon Database Migration Service
Amazon Database Migration Service (AWS DMS) is a SaaS service for moving relational databases, data warehouses, NoSQL databases and other data stores to AWS or between cloud and on-premises environments. It handles one-time migrations and continuous replication, with support for both like-for-like and cross-engine moves. AWS says more than 20 databases and data warehouses can serve as source or target endpoints. DMS Schema Conversion assesses schemas and converts many code objects, including views, stored procedures and functions, while identifying work that needs manual conversion. DMS Serverless provisions and scales capacity according to transaction volume, billed hourly. Multi-AZ deployment uses redundant replication instances, and interrupted migrations can resume. API and AWS CLI support automation, while CloudTrail and CloudWatch Logs provide integrations. TLS, VPC deployment, PrivateLink and column masking are available. At least one endpoint must be Amazon RDS or EC2; on-premises-to-on-premises replication is unsupported. The AWS Free Tier offers free with credits.
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.