- Newest
- Most votes
- Most comments
Can you confirm you have followed these steps to set-up the source Oracle database - https://docs.aws.amazon.com/dms/latest/sbs/chap-on-premoracle2aurora.steps.configureoracle.html
Thank you for your response.
Yes. I did all the settings as in the document. It was working fine for Oracle to Oracle RDS data replication.
Now trying to do the same for Oracle to Postgres RDS.
I am sure it is some privilege missing on the target instance. Not sure, what it is.
Hello,
As DMS task worked fine with Oracle to Oracle RDS data replication, the difference between Postgres would come for tables names. Oracle treat all table name in CAPITAL letter but postgres is the opposite, all in LOWERCASE. Most likely you would need to add transformation rule to convert all table and schema name to lower case.
Hope that helps, if not, then pls. share the dms log for understanding it more.
Thanks
Relevant content
- asked a month ago
- asked 10 months ago
- Accepted Answerasked 6 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Not sure if this will help, but this document does have some troubleshooting tips - https://docs.amazonaws.cn/en_us/dms/latest/userguide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.General.NothingMigrated