Mysql Aurora的AWS DMS

发布于 2025-01-17 16:05:26 字数 135 浏览 4 评论 0 原文

我正在尝试将MySQL Aurora数据库复制到另一个MySQL Aurora。始终以与源相同的名称创建数据库。有什么方法可以指定目标数据库名称？意思是，我想将“ X”表复制到数据库中的数据库中B数据库的“ X”表。

ax =＆gt; Bx

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

街道布景 2025-01-24 16:05:26

您可以为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"
        }
    ]
}

这将从公共模式中复制所有表，并将其重命名为您指定的一个。

详细的文档在这里：

You can specify a table mapping rule for your DMS replication task as follows:

{

    "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"
        }
    ]
}

This will copy all tables from public schema and rename just the one you specify.

Detailed documentation is here: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.html

回复收藏 0 原文

~没有更多了~