Create a DMS Migration Task

AWS DMS uses Database Migration Task to migrate the data from source to the target database. For this migraiton, you are going to create two Database Migration Tasks: one for migrating the existing data, and another for capturing data changes on the source database and replicating the changes to the target database.

  1. Click on Database migration tasks on the left-hand menu, then click on the Create task button on the top right corner.


  1. Create a data migration task with the following values for migrating the dms_sample database.

    Parameter Value
    Task identifier oracle-migration-task
    Replication instance dmsreplication
    Source database endpoint oracle-source
    Target database endpoint oracle-target
    Migration type Migrate existing data
    Target table preparation mode Do nothing
    Include LOB columns in replication Limited LOB mode
    Max LOB size (KB) 32
    Enable validation Unchecked
    Enable CloudWatch logs Checked
  2. Expand the Table mappings section, and select Wizard for the editing mode.

  3. Click on Add new selection rule button and enter the following values in the form:

    Parameter Value
    Schema DMS_SAMPLE
    Table name %
    Action Include

If the Create Task screen does not recognize any schemas, make sure to go back to endpoints screen and click on your endpoint. Scroll to the bottom of the page and click on Refresh Button (⟳) in the Schemas section. If your schemas still do not show up on the Create Task screen, click on the Guided tab and manually select DMS_SAMPLE schema and all tables.


  1. After entering the values, make sure Migration task startup configuration is set to start Automatically on create, then click on Create task.

  2. At this point, the task should start migrating data from the source Oracle database to the Amazon RDS Oracle instance.


  1. As the rows are being transferred, you can monitor the task progress:
    1. Click on your task (oracle-migration-task) and scroll to the Table statistics section to view the table statistics to see how many rows have been moved.
    2. If there is an error, the status color changes from green to red. Click on View logs link for the logs to debug.