This talk tells a real‑world story of migrating a sizable on‑premises PostgreSQL database to AWS RDS using AWS DMS (Database Migration Service) and SCT (Schema Conversion Tool). I discuss the advantages and disadvantages of both services and explain how they can (or can’t) help you with database migrations. By walking through the migration process step by step, I highlight common pitfalls and obstacles such as missing defaults, constraint violations, schema mismatches, and sequence‑handling issues that often catch teams off guard. Along the way, I share practical lessons learned, including strategies for effective pre‑migration planning, testing, and validation, as well as tips for blending automated tools with manual adjustments to ensure a smooth, reliable transition to the cloud.

Level 200 (Intermediate).

This talk has been performed at AWS User Group 3City (https://www.meetup.com/aws-user-group-3city/events/295170493) and AWS User Group The Netherlands (https://www.meetup.com/awsugnl/events/306912455).
Watch the recording of this session: https://www.youtube.com/live/qyTNSk9c58M/