Sample Header Ad - 728x90

Do not replicate Delete operations AWS DMS

3 votes
1 answer
5501 views
I am using **AWS DMS** to replicate ongoing changes with **SQL Server** as a source and target endpoint. The tasks are running and replicating data with low latency. However, I need the tasks configured not to replicate DELETE operations from the source database. I did read the whole documentation of the tool and I wasn't able to find such a configuration option to exclude **DELETE** statements for replicating. There is only one place in the whole user guide where it states that if one is performing a **Full Load plus CDC** or a **CDC-only** task, it is recommended the migration to be paused and secondary indexes to be created that will support filtering for update and delete statements. But no more, no further explanation. Any help or experience is highly appreciated, please.
Asked by tOpsDvp (41 rep)
Aug 13, 2019, 12:58 PM
Last activity: May 18, 2020, 10:05 PM