logo

Migration from oracle to postgres in 1hr live demo | S01 E22 | Lets Talk About Data Show 

In this show we discuss and build Oracle to PostgreSQL migration solution using AWS Database Migration service and AWS Schema Conversion Tool

Prasad Matkar
Prasad Matkar
Amazon Employee
Tony Mullen
Tony Mullen
Amazon Employee
Published Sep 20, 2023

Screenshot from the stream or an image related to the topic

In this episode of Lets Talk About Data we discuss and build Oracle to PostgreSQL migration solution using AWS Database Migration service and AWS Schema Conversion Tool.

Check out the recording here:

Tony Mullen, Senior RDS Specialist Solutions Architect @ AWS

Vetrivel Subramani, Cloud Support DBA @ AWS

  • SCT - https://aws.amazon.com/dms/schema-conversion-tool/
  • DMS - https://aws.amazon.com/dms/
  • Workshop link - https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/oracle-aurora
  • Install schema conversion tool - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html
  • Oracle as a Source chapter in the DMS documentation.
    https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html
  • Run SQL*Plus script - as a pre-check: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SupportScripts.Oracle.html
  • Logminer or binary reader - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.CDC
  • Lob support - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html

  • Tony: (https://www.linkedin.com/in/tony-mullen-8b05927d)
  • Vetrivel: (https://www.linkedin.com/in/vetrivel-cloud-enthusiast/)