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?
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-lReceived on Tue Nov 19 2024 - 17:45:48 CET