用于MySQL Aurora的AWS

Question

我正在尝试将MySQL Aurora数据库复制到另一个MySQL Aurora。它总是创建与源名称相同的数据库。有任何方法来指定目标DB名称吗？也就是说，我想将"x“表复制到A数据库到B数据库的"x”表。

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