Migrating an Oracle Database to PostgreSQL - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migrating an Oracle Database to PostgreSQL

Using this walkthrough, you can learn how to migrate an Oracle database to a PostgreSQL database using Amazon Database Migration Service (Amazon DMS) and the Amazon Schema Conversion Tool (Amazon SCT).

Amazon DMS migrates your data from your Oracle source into your PostgreSQL target. Amazon DMS also captures data manipulation language (DML) and supported data definition language (DDL) changes that happen on your source database and applies these changes to your target database. This way, Amazon DMS keeps your source and target databases in sync with each other. To facilitate the data migration, Amazon SCT creates the migrated schemas on the target database, including the tables and primary key indexes on the target if necessary.

Amazon DMS doesn’t migrate your secondary indexes, sequences, default values, stored procedures, triggers, synonyms, views, and other schema objects not specifically related to data migration. To migrate these objects to your PostgreSQL target, use Amazon SCT.

Topics