AWS Schema Conversion Tool vs Ora2Pg

AWS Schema Conversion Tool (AWS SCT) converts database schemas between engines, including relational OLTP, data warehouse, and NoSQL schemas. If it cannot automate a conversion, it gives guidance for creating an equivalent schema in the target database. A project wizard estimates migration complexity for supported destinations and generates a report for comparing target options. For warehouse migrations to Amazon Redshift, it can manage data extraction agents; it can also create, run, and monitor AWS DMS endpoints and tasks. AWS SCT converts SQL embedded in C++, C#, Java, and other application code for users to review, edit, and save. Supported workload conversions include SSIS packages, Teradata workloads, and Apache Oozie workflows to specified AWS services. It is both a standalone, project-based application and a command-line tool. Planned converted schemas stay local until applied to the target. AWS SCT is free and supports 64-bit Microsoft Windows, Fedora Linux, and Ubuntu Linux. It also supports FIPS standards for connections to Amazon S3 or another AWS resource and is compliant with FedRAMP.

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.