- 最新
- 最多得票
- 最多評論
Hi Sam, AWS Schema Conversion Tool (SCT) can be used to create your target database based on definitions of the source one. See https://aws.amazon.com/dms/schema-conversion-tool/
More info about SCT UI: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_UserInterface.html
Oracle is among the supported source databases: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.html
How-to of Oracle migration with SCT + DMS: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.html
According to this: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Oracle.html
When using Oracle as a target, AWS DMS migrates all tables and indexes to default table and index tablespaces in the target.
It also has limitations such as lack of automatic schema creation: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Oracle.html#CHAP_Target.Oracle.Limitations
That might require some manual work if there large number of schemas to move. I am not sure if it will create all objects in new schema and then copy data.
Have you seen a video that demonstrates how this is done? It seems might be more reliable to use an export data pump for this.
相關內容
- 已提問 10 個月前
AWS 官方已更新 7 個月前- AWS 官方已更新 2 年前
- AWS 官方已更新 3 年前
- AWS 官方已更新 3 年前
It seems there is still some manual work to do using SCT to copy oracle schemas from one RDS to another and it is one schema at a time. It sounds using data pump export/import might be easier.
Have you seen a video or article that shows the details of copying oracle schema/database using SCT?
It seems there is still some manual work to do using SCT to copy oracle schemas from one RDS to another and it is one schema at a time. It sounds using data pump export/import might be easier.
Have you seen a video or article that shows the details of copying oracle schema/database using SCT?