AWS Database Migration Workshop

Amazon Aurora is a MySQL and PostgreSQL compatible relational database built for the cloud that combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.

In this hands-on workshop, you learn to migrate Oracle databases to Aurora PostgreSQL with minimum downtime using the AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).

This lab demonstrates how to use:

• AWS Schema Conversion Tool (SCT) for database schema conversion
• AWS Database Migration Service (DMS) for data migration

---

Reference Architecture

---

Prerequisites

The following prerequisites must be met before you begin the workshop:

• AWS Console Access
• RDP client

---

Workshop Activities

1. Lab Setup
2. Schema Conversion Tool (SCT)
3. DMS - Replication Instance & Endpoints
4. DMS - Replication Task for full-load
5. DMS - Replication Task for Change Data Capture (CDC)
6. Validation - Using web application
7. Fixing issues with numeric data types
8. Optional : Resolving SCT action items
9. Cleanup

License

This library is licensed under the MIT-0 License. See the LICENSE file.

---