Hi, I am looking to migrate from on-prem Oracle to AWS using the AWS Data Migration Service.
Our previous attempts to utilize AWS DMS for data migration encountered challenges due to the absence of primary and foreign key constraints in the database.
Is there any way we can use replication or a migration service to migrate the DB? The DB is over 4TB and we are not keen to use a “lift and shift” which could take longer; the idea is to use some form of replication between the two DB's to bring them in sync while we move the applications across.
Any help is appreciated.