Migrate tables with LOBs from RDS MySQL to OpenSearch using DMS

Question

I'm trying to migrate data from **RDS for MySQL** to **OpenSearch** using **DMS**, but since DMS can't migrate **LOBs** to OpenSearch, fields with **longtext **data type **are missed** from the OpenSearch.

I tried to use **DMS transformation rules** to transform longtext to **string** data type, but it didn't work!

What is the best solution to migrate all fields to OpenSearch without missed columns??

Answer

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html#CHAP_Validating.Limitations Please refer this limitations

Answer

Currently while migrating to Opensearch target AWS DMS doesn't support migration of LOB data types.

ref: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Elasticsearch.html#:~:text=table%2Dname.-,Migrating%20from%20a%20relational%20database%20table,-to%20an%20OpenSearch

Migrate tables with LOBs from RDS MySQL to OpenSearch using DMS

Relevanter Inhalt