AWS Logo
Menu

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

awsdatatwitchlets-talk-about-data
Prasad Matkar
Amazon Employee
Published Sep 20, 2023
Last Modified Apr 22, 2024
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:
Loading...

Hosts of the show 🎤

Tony Mullen, Senior RDS Specialist Solutions Architect @ AWS

Guests

Vetrivel Subramani, Cloud Support DBA @ AWS

Links from today's episode

  • 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

Reach out to the hosts and guests:

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

Any opinions in this post are those of the individual author and may not reflect the opinions of AWS.

Comments