Step 9: Create and Run Your AWS DMS Migration Task - Database Migration Guide

Step 9: Create and Run Your AWS DMS Migration Task

Using an AWS DMS task, you can specify what schema to migrate and the type of migration. You can migrate existing data, migrate existing data and replicate ongoing changes, or replicate data changes only. This walkthrough migrates existing data only.

  1. On the Create Task page, specify the task options. The following table describes the settings.

    Parameter Action

    Task name

    Enter migrateSHschema.

    Replication instance

    Shows DMSdemo-repserver (the AWS DMS replication instance created in an earlier step).

    Source endpoint

    Shows orasource (the Amazon RDS for Oracle endpoint).

    Target endpoint

    Shows redshifttarget (the Amazon Redshift endpoint).

    Migration type

    Choose Migrate existing data.

    Start task on create

    Choose this option.

    The page should look like the following.

    Create task page

  2. On the Task Settings section, specify the settings as shown in the following table.

    Parameter Action

    Target table preparation mode

    Choose Do nothing.

    Include LOB columns in replication

    Choose Limited LOB mode.

    Max LOB size (kb)

    Accept the default (32).

    The section should look like the following.

    Create task page

  3. In the Selection rules section, specify the settings as shown in the following table.

    Parameter Action

    Schema name is

    Choose Enter a schema.

    Schema name is like

    Enter SH%.

    Table name is like

    Enter %.

    Action

    Choose Include.

    The section should look like the following:

    Add selection rule page

  4. Choose Add selection rule.

  5. Choose Create task. The task begins immediately. The Tasks section shows you the status of the migration task.

Tasks page