0

We use AWS DMS to transfer the data from one postgres db to another postgres. The DMS fails if the data has specail characters in the json.

For example,

Table column data type is jsondata
Value in source DB: {'comment': 'datakey!34FRE'}

Could anyone give me suggestion to rectify this issue?

I tried replacing the special characters with CHR codes using filters

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Expressions.html

it didnt help

Thanks in advance, Harika

Harika K
  • 31
  • 3

0 Answers0