Oracle RDS Replication To Redshift

From: Ethan Post <"Ethan>
Date: Tue, 19 Nov 2024 10:45:48 -0600
Message-ID: <CAMNhnU064y6ozVB0hD87ynQYw2stenBBn-ND-P3vXxfyKFzZiA_at_mail.gmail.com>



Anyone here set up a data sync from Oracle RDS DB to Redshift?

Searches suggest that I can use AWS data migration service and just leave it running in sync? Other answers seem to suggest AWS Glue (don't know much about ease of use/features with that). Other answers suggest FiveTran and I assume other competitors like STRIIM may do this. So a lot of potential possibilities. Would be interesting to hear your solutions if you have one implemented. I also see possible issues with lack of PKs if DB doesn't have them and LOBs (my DB likely has both of these issues) with some replication solutions.

Thanks!

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 19 2024 - 17:45:48 CET

Original text of this message