By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Migrate tables with LOBs from RDS MySQL to OpenSearch using DMS

0

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

Topics
Migration & ModernizationAnalyticsDatabaseServerless
Tags
Migration & ModernizationAnalyticsAWS Database Migration ServiceAmazon Relational Database ServiceAmazon OpenSearch Service
Language
English
obadaqaf
asked 2 years ago1158 views
2 Answers
0

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

AWS
subhashr
answered 2 years ago
0

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

iamvijaykishan
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content