DMS : Possibility of using like operator in DMS

Question

Hi,

We are using DMS for migrating from Oracle to S3. Is there any option to use the 'like' operator in the input table to filter data in Table Mappings?

Answer

Hi there.

There doesn't seem to be such operator. Per the [documentation](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.Filters.html), only the following are available:

* `lte` – less than or equal to one value
* `ste` – less than or equal to one value (lte alias)
* `gte` – greater than or equal to one value
* `eq` – equal to one value
* `noteq` – not equal to one value
* `between` – equal to or between two values
* `notbetween` – not equal to or between two values
* `null` – NULL values
* `notnull` – no NULL values

I hope this helps.

DMS : Possibility of using like operator in DMS

Relevant content