Question

How to migrate oracle database to postgresql rds step by step proces?

Answer 1

Step-by-Step Migration

In the following sections, you can find step-by-step instructions for migrating an Amazon Relational Database Service (Amazon RDS) Oracle database to Amazon Aurora MySQL. These steps assume that you have already prepared your source database as described in preceding sections.

Topics

Step 1: Launch the RDS Instances in a VPC by Using the CloudFormation Template

Step 2: Install the SQL Tools and AWS Schema Conversion Tool on Your Local Computer

Step 3: Test Connectivity to the Oracle DB Instance and Create the Sample Schema

Step 4: Test the Connectivity to the Aurora MySQL DB Instance

Step 5: Use the AWS Schema Conversion Tool (AWS SCT) to Convert the Oracle Schema to Aurora MySQL

Step 6: Validate the Schema Conversion

Step 7: Create a AWS DMS Replication Instance

Step 8: Create AWS DMS Source and Target Endpoints

Step 9: Create and Run Your AWS DMS Migration Task

Step 10: Verify That Your Data Migration Completed Successfully

Step 11: Delete Walkthrough Resources