- Le plus récent
- Le plus de votes
- La plupart des commentaires
This blog Migrating Oracle databases with near-zero downtime using AWS DMS provides some good technical guidance to evaluate
The solution in blog includes the following steps:
- Provision an AWS DMS replication instance with the source and target endpoints
- Export the schema using Oracle Data Pump from the on-premises Oracle database
- Import the schema using Oracle Data Pump into the Amazon RDS for Oracle database
- Create an AWS DMS replication task using CDC to perform live replication
- Validate the database schema on the target Amazon RDS for Oracle database
Reference : https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/
Hello,
As this your planning to migrate on-premises Oracle to Amazon RDS for Oracle database, most of the native tool like datapump, also can help in migration. In case you do not have downtime window to carry out datapump export import then you may plan to use DMS replication.
In both cases, its good to create metadata first (schema, table, etc.) before importing or start replicating data.
I do no think DMS can create schema. Also pls. review https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-oracle-database-to-amazon-rds-for-oracle.html
Thanks
Hello,
As suggested the best approach would be to use the native replication tools like Data pump to create the Database skeleton (metadata) and post migrate the data using the AWS DMS. Alot depends on the dynamics involved like the size , downtime and the underlying the NW bandwidth between On-premise DC and the AWS. AWS Schema conversion tool (AWS SCT) also provides capability for schema conversion between Onpremise Oracle to Amazon Oracle RDS. The steps on high level would be - Assessment -> Schema Conversion -> Data Migration.
Please refer to this workshop for your hands-on and detailed instructions # https://catalog.us-east-1.prod.workshops.aws/workshops/77bdff4f-2d9e-4d68-99ba-248ea95b3aca/en-US/oracle-oracle
Contenus pertinents
- demandé il y a un an
- demandé il y a un mois
AWS OFFICIELA mis à jour il y a 7 mois- AWS OFFICIELA mis à jour il y a un an
Thank you Nitin! I read the blog but wondering if we can export/import schema without Oracle Data Pump? Is there a way to use AWS DMS/SCT? What steps will be required? e.g create all the schemas first on target then use DMS to migrate data?