Can DMS support selective ignoring of certain binlog commands?

Hello.

Yes, AWS Database Migration Service (DMS) provides a way to selectively replicate or ignore specific events from source database binlogs. When you create or modify a migration task, you can specify table mappings to determine how specific tables are migrated. Within these table mappings, you can use the action attribute to determine how specific operations on those tables are handled. For example, to ignore ALTER TABLE commands related to dropping partitions on table t1, you'd set up a transformation rule like this:

{
  "rule-type": "transformation",
  "rule-id": "1",
  "rule-name": "1",
  "rule-target": "table",
  "object-locator": {
    "schema-name": "your_schema_name",
    "table-name": "t1"
  },
  "rule-action": "DoNothing"
}

Regards, Andrii

The example I provided with "rule-action": "DoNothing" would ignore all operations for the specified table, which is not what you want.

If you specifically want to ignore only the ALTER TABLE DROP PARTITION commands while allowing other alterations and commands to proceed, you won't be able to achieve this directly using DMS's built-in functionalities.