How do I set up table mappings in AWS DMS?

Last updated: 2019-05-16

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

Resolution

  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. Select 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, select Include or Exclude.
  9. Choose Create task.

To add table mappings to a task that already exists, choose Database migration tasks from the navigation pane. Select your task, choose Actions, and then choose Modify. From the Table mappings section, expand Selection rules, and then choose Add new selection rule. Enter the details of your selection rule, and then choose Save.