Specifying table selection and transformations rules from the console - AWS Database Migration Service

Specifying table selection and transformations rules from the console

You can use the AWS Management Console to perform table mapping, including specifying table selection and transformations. On the console, use the Where section to specify the schema, table, and action (include or exclude). Use the Filter section to specify the column name in a table and the conditions that you want to apply to a replication task. Together, these two actions create a selection rule.

You can include transformations in a table mapping after you have specified at least one selection rule. You can use transformations to rename a schema or table, add a prefix or suffix to a schema or table, or remove a table column.

Note

AWS DMS doesn't support more than one transformation rule per schema level or per table level. However, AWS DMS does support more than one transformation rule per column level.

The following procedure shows how to set up selection rules, based on a table called Customers in a schema called EntertainmentAgencySample.

To specify a table selection, filter criteria, and transformations using the console

  1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

    If you are signed in as an IAM user, make sure that you have the appropriate permissions to access AWS DMS. For more information about the permissions required, see IAM permissions needed to use AWS DMS.

  2. On the Dashboard page, choose Tasks.

  3. Choose Create Task.

  4. Enter the task information, including Task name, Replication instance, Source endpoint, Target endpoint, and Migration type. Choose Guided from the Table mappings section.

    
                            Schema and table selection
  5. In the Table mapping section, choose the schema name and table name. You can use "%" as a wildcard value when specifying the table name. Specify the action to be taken, to include or exclude data defined by the filter.

    
                            Schema and table selection
  6. Specify filter information using the Add column filter and the Add condition links.

    1. Choose Add column filter to specify a column and conditions.

    2. Choose Add condition to add additional conditions.

    The following example shows a filter for the Customers table that includes AgencyIDs between 01 and 85.

    
                            Schema and table selection
  7. When you have created the selections you want, choose Add selection rule.

  8. After you have created at least one selection rule, you can add a transformation to the task. Choose add transformation rule.

    
                            transformation rule
  9. Choose the target that you want to transform, and enter the additional information requested. The following example shows a transformation that deletes the AgencyStatus column from the Customer table.

    
                            transformation rule
  10. Choose Add transformation rule.

  11. (Optional) Add additional selection rules or transformations by choosing add selection rule or add transformation rule. When you are finished, choose Create task.

    
                            transformation rule
Note

AWS DMS doesn't support more than one transformation rule per schema level or per table level. However, AWS DMS does support more than one transformation rule per column level.