Step-by-step Oracle database to PostgreSQL migration walkthrough
The following steps provide instructions for migrating an Oracle database to a PostgreSQL database. These steps assume that you have already prepared your source database as described in Prerequisites.
Topics
- Step 1: Install the SQL Drivers and AWS Schema Conversion Tool on Your Local Computer
- Step 2: Configure Your Oracle Source Database
- Step 3: Configure Your PostgreSQL Target Database
- Step 4: Use AWS SCT to Convert the Oracle Schema to PostgreSQL
- Step 5: Create an AWS DMS Replication Instance
- Step 6: Create AWS DMS Source and Target Endpoints
- Step 7: Create and Run Your AWS DMS Migration Task
- Step 8: Cut Over to PostgreSQL
