适用于MySQL Aurora的AWS DMS

Question

我正在尝试将MySQL Aurora数据库复制到另一个MySQL Aurora。它总是创建与源名称相同的数据库。有什么方法可以指定目标数据库名称吗？意思是，我想复制"；x〃；表到数据库到"；x〃；B数据库的表。

A.x=>B.x

Answer 1

您可以为DMS复制任务指定一个表映射规则，如下所示：

{
"rules": [
{
"rule-type": "selection",
"rule-id": "1",
"rule-name": "1",
"object-locator": {
"schema-name": "public",
"table-name": "%"
},
"rule-action": "include"
},
{
"rule-type": "transformation",
"rule-id": "2",
"rule-name": "2",
"rule-action": "rename",
"rule-target": "table",
"object-locator": {
"schema-name": "public",
"table-name": "old-table"
},
"value": "new-table"
}
]
}

这将从公共架构中复制所有表，并仅重命名您指定的表。

详细文档如下：https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.html