Reload only one table in CDC Task

Question

Team, we have two replication tasks in DMS (Postgresql to S3), Full load only task and a CDC ongoing replication task. Request to get a new table onboarded to the replication. as part of the request the new table to be onboarded is an existing table in the source and it needs to get full load as part of the first run.

I know if the replication task is designed to be one (full load and CDC) we have an option to do a full load on one single table.

Seeking your inputs and suggestions in getting this table added to replication with minimal disruption. How do we get the full load for this one single table, any alternate suggestions other than creating an another full load replication task in DMS.

Diwakar · Answer

To reload a table, the following conditions must apply:

The task must be running.

The migration method for the task must be either full load or full load with CDC.

The task i have is CDC only task.

Ruchir_A · Answer

Since the table you are looking to add to the scope of the CDC-only task already exists, when you add the table to the CDC-only task's scope, its existing data cannot be loaded by the CDC-only task. You will have to create a separate full load only task to load the initial/existing data.

You are correct that the table reload option exists only for the full load or full load with CDC tasks.

Reload only one table in CDC Task

Füge deine Antwort hinzu

Relevanter Inhalt