AWS DMS Replication Task
How do I add a new table to an existing replication task and start CDC for it while not impacting/breaking the existing tables on going replication?
Suppose Oracle to Oracle engine. I already have 4 tables in task and cdc is running and in sync. Now I want to add 5th table to it. I did full load for it using native tool(data pump expdp/impdp using flashback_scn) after that I want to start CDC for it. Now do I create a new task for it or add to existing? Can someone please help me understand how to handle such requests.
TIA
you can always add a new table in selection for cdc task but linking of expdp/impdb with scn would be an issue with existing task. I would suggest create a new cdc only task for the new table with start scn from the expdp/impdb
if we had original full load and cdc task then it would have been easy to stop the running task, add new table, resume task which will do full load and cdc.
Relevant questions
AWS DMS Replication Task
asked a month agoDMS CDC task (Oracle->S3, binary reader) "hangs" without failing, misses changes
asked 6 months agoSupport for RDS Oracle as source while using DMS SCN for CDC
Accepted Answerasked 4 years agoDMS CDC for SQL Server - Replication
Accepted AnswerDMS: How does a replication task handle duplicate data w/o Primary/Unique keys on the table
asked 19 days agoReplication between RDS and on premises Oracle
Accepted Answerasked 2 years agoHow to enable Logical Replication for existing Aurora PG 13 Cluster?
asked 7 months agoUsing DMS CDC for Oracle to Postgres
asked 6 days agoResolution for Fatal error when using DMS for on-going replication from RDS Postgres to S3
Accepted Answerasked a year agoOracle Migration from on-premises using DMS and Rman
Accepted Answerasked 2 years ago