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 Amazon Schema Conversion Tool on Your Local Computer
- Step 2: Configure Your Oracle Source Database
- Step 3: Configure Your PostgreSQL Target Database
- Step 4: Use Amazon SCT to Convert the Oracle Schema to PostgreSQL
- Step 5: Create an Amazon DMS Replication Instance
- Step 6: Create Amazon DMS Source and Target Endpoints
- Step 7: Create and Run Your Amazon DMS Migration Task
- Step 8: Cut Over to PostgreSQL