Migrate tables with LOBs from RDS MySQL to OpenSearch using DMS

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??

주제

마이그레이션 및 현대화 분석 데이터베이스 서버리스

태그

마이그레이션 및 현대화 분석 AWS 데이터베이스 마이그레이션 서비스 아마존 Relational Database Service 아마존 OpenSearch 서비스

언어

English

obadaqaf

질문됨 2년 전1188회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

subhashr

답변함 2년 전

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

iamvijaykishan

답변함 2년 전

Migrate tables with LOBs from RDS MySQL to OpenSearch using DMS

관련 콘텐츠