How do I create a task in AWS DMS and turn on control tables?

Last updated: 2022-10-31

I want to create an AWS Database Migration Service (AWS DMS) task, and then turn on control tables for my task.

Resolution

Before you create a task and turn on control tables, first create a replication instance, source endpoint, and target endpoint for your task. Control tables are for change data capture (CDC) operations only. If you experience issues during a full load, you might not be able to see any information in the control tables.

  1. Open the AWS DMS console, and then choose Database migration tasks from the navigation pane.
  2. Choose Create task.
  3. From the Create data migration task section, choose the replication instance, source, and target endpoints that you created.
  4. For Migration type, choose one of these options:
    Migrate existing data
    Migrate existing data and replicate ongoing changes
    Replicate data changes only
  5. From the Task settings section, from Target table preparation mode, choose one of these options:
    Do nothing - This creates the table if a table isn't on the target. If a table exists, this leaves the data and metadata unchanged.
    Drop tables on target - This drops the table at the target and recreates the table.
    Truncate - This truncates the data and leaves the table and metadata intact.
  6. From the Task settings section, from Include LOB columns in replication, choose one of these options:
    Don't include LOB columns
    Full LOB mode - Specify the LOB chunk size. If you have large binary objects (LOBs), this can slow your migration because AWS DMS doesn't know the exact size of the LOBs. AWS DMS fetches LOBs in chunks as specified by the LOB chunk size until the full size is recovered. Then, AWS DMS migrates the LOBs to the target.
    Limited LOB mode - Specify the maximum LOB size. This is the size of the largest LOB you are migrating, so you must query your source database for this information.
  7. Choose Enable CloudWatch logs.
    Note: If you choose Enable validation, the task requires additional time to complete.
  8. From the Table mappings section, add your schemas and tables.
  9. Expand Advanced task settings.
  10. In the Create control table in target using schema field, enter a schema for your control table. If you don't enter any information in the schema field, the tables are copied to the default location in the database. See the following default locations for each database engine:
    PostgreSQL - Public
    Oracle - the target schema
    SQL Server - dbo in target database
    MySQL - awsdms_control
    MariaDB - awsdms_control
    Amazon Redshift - Public
    Amazon DynamoDB - created as individual tables in the database
  11. In the History timeslot (minutes) field, enter the number of minutes that each record remains in the replication history table.
  12. For the following control tables, turn on these options:
    Apply exceptions - This table can't be turned off, and it contains the exceptions, errors, and information on the statement that was running when the error occurred.
    Replication status - This table provides details about the current task. This includes task status, amount of memory consumed by the task, and the number of changes not yet applied to the target. This table tells you where on the source AWS DMS is reading, and indicates if the task is a full load or CDC.
    Suspended tables - This table provides a list of suspended tables and the reason that the tables were suspended.
    Replication history - This table provides information about replication history. This information includes the number and volume of records processed during the task. It also includes latency at the end of a CDC task, and other statistics.
  13. Choose Create task.
  14. Run the task, and then check the target database for the schema and tables.

To change the control table settings for your task, choose Database migration tasks from the navigation pane. Select your task, choose Actions, and then choose Modify. From the Advanced task settings section, you can change the Control table settings. Then, choose Save.


Did this article help?


Do you need billing or technical support?