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??
Currently while migrating to Opensearch target AWS DMS doesn't support migration of LOB data types.
DMS service for hive table migrationAccepted Answerasked 2 years ago
Migrate MySQL 5.5 to AWSAccepted AnswerEXPERTasked 3 years ago
About DMS migration from ms-sql to dynamodbasked 22 days ago
Migrate tables with LOBs from RDS MySQL to OpenSearch using DMSasked a month ago
Migrate MySQL 8 to Aurora MySQL 8asked 4 months ago
Do source filters speed up DMS from AWS RDS to S3?asked 6 months ago
migrate database from my local to AWSAccepted Answerasked 3 years ago
DMS to OpenSearch decimal problemasked 3 months ago
DMS to migrate SQL Server from RDS to EC2asked 2 years ago
AWS DMS Postgres to OpenSearch LOB handlingasked 5 months ago