Skip to content
SPECIFICTION
Get listed

Amazon Database Migration Service vs Ora2Pg

Amazon Database Migration Service

aws.amazon.com

Ora2Pg

ora2pg.darold.net

Side by side

FigureAmazon Database Migration ServiceOra2Pg
Price fromFreeFree
Free planYesYes
Free trial——
Open source——
WebYes—
Windows—Yes
Linux—Yes
APIYes—
Self-hosted—Yes
Plans published41
Spec score · Cloud Migration Tools8.7 (#2)7.5 (#17)
Spec score · Data Migration Tools8.8 (#2)7.4 (#10)
PurposeAWS 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

Amazon Database Migration Service pricing →

Ora2Pg

  • Ora2PgFree

Ora2Pg pricing →

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.

Visit aws.amazon.com

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.

Visit ora2pg.darold.net