Menu
AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

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.

To create a migration task

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

    For This Parameter Do This

    Task name

    Type 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 the option 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.

    For This Parameter Do This

    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.

    For This Parameter Do This

    Schema name is

    Choose Enter a schema.

    Schema name is like

    Type SH%.

    Table name is like

    Type %.

    Action

    Choose Include.

    The section should look like the following:

    
                                 Add selection rule page
  4. Choose Add selection rule.

  5. Choose Create task.

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


                        Tasks page