在使用AWS的DMS进行迁移期间是否可以转换数据 [英] Is it possible to transform data during a migration with AWS's DMS

问题描述

在使用AWS Data Migration Service执行迁移时，是否可以转换实际数据?我正在尝试将数据从PostgreSQL迁移到DynamoDB，并为DMS带来的数据添加前缀.据我所知，迁移任务中可用的所有转换规则似乎仅适用于表本身的组件(列名，表名，架构名).

Is it possible to transform actual data while performing a migration with the AWS Data Migration Service? I'm trying to migrate data from PostgreSQL to DynamoDB and to append a prefix to the data that is brought over with DMS. From what I can tell, it looks like all of the transformation rules that are available in the migration task only apply to components of the table themselves (column names, table names, schema names).

基本上，我想在Postgres中找到类似的东西 ID:123成为Dynamo中的ID:pre_123.

Basically I would like something like this in Postgres ID:123 to become ID:pre_123 in Dynamo.

推荐答案

您可以将列的对象映射规则设置为"value" ="pre _ $ {columnName}"或任何实际语法. http://docs中提供了有关示例映射的更多信息. aws.amazon.com/dms/latest/userguide/CHAP_Target.DynamoDB.html

You can set up an object mapping rule for a column to be "value" = "pre_${columnName}" or whatever the actual syntax is. More about mappings with examples is given in http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.DynamoDB.html

这篇关于在使用AWS的DMS进行迁移期间是否可以转换数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！