How do I set up table mappings in AWS DMS?

2 minute read
0

How do I set up table mappings in AWS Database Migration Service (AWS DMS)?

Resolution

Use the steps in this article to set up table mapping on your AWS DMS task using the AWS DMS console. For more information on working with table mapping and how it can be used, see Using table mapping to specify task settings. You can also use transformations in a table mapping to perform tasks like renaming tables, and removing a table column. You must choose at least one selection rule for your task to work correctly, and to use transformation rules on your task. For more information, see the limitations of using transformation rules.

Follow these steps to set up table mappings.

  1. Open the AWS DMS console, and then choose Database migration tasks from the navigation pane.
  2. Choose Create task.
  3. Enter the details for your Task configuration and Task settings.
  4. Choose Enable CloudWatch logs.
  5. From the Table mappings section, choose Guided UI. You can also choose JSON editor to enter the mappings in JSON format.
  6. From the Selection rules section, choose Add new selection rule.
    Note: To add more than one selection rule, choose Add new selection rule again.
  7. Enter your Schema and a Table name. Enter % to select all available schemas or tables.
  8. For Action, choose Include or Exclude.
  9. Choose Create task.

To add table mappings to a task that already exists:

  1. Choose Database migration tasks from the navigation pane.
  2. Choose your task, choose Actions, and then choose Modify.
  3. From the Table mappings section, expand Selection rules, and then choose Add new selection rule.
  4. Enter the details of your selection rule, and then choose Save.

Related information

Creating a task

Troubleshooting migration tasks in AWS Database Migration Service

How can I turn on monitoring for an AWS DMS task?

AWS OFFICIAL
AWS OFFICIALUpdated a year ago