Home icon

How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation (Part 1)

Database Blog

This article provides a step-by-step guide for migrating Oracle databases to Amazon Aurora PostgreSQL using AWS DMS and CloudFormation.

  • Use AWS DMS Schema Conversion to convert Oracle schemas to PostgreSQL-compatible format
  • CloudFormation template deploys Oracle RDS, Aurora PostgreSQL cluster, and DMS replication instance
  • Schema conversion assesses objects, identifies manual intervention needs, and exports results
  • AWS DMS migrates data using bulk load with validation and CloudWatch logging enabled
  • Table mappings handle case sensitivity differences between Oracle and PostgreSQL
  • Limited LOB mode optimizes performance for large object data migration
  • Deployment takes 20-30 minutes; full walkthrough completes in under one hour

This two-part migration approach systematically modernizes database infrastructure while maintaining data integrity and application functionality.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 3
2026
Migrating data from Oracle to Amazon Aurora DSQL
Oct 28
2025
Migrate Oracle reference partitioned tables to Amazon RDS or Aurora PostgreSQL with AWS DMS
Jul 1
2024
AWS DMS homogenous migration from PostgreSQL to Amazon Aurora PostgreSQL
Feb 8
2024
Migrate Oracle collections to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.