AWS Database Migration Service
User Guide (Version API Version 2016-01-01)

Creating a Task

There are several things you must do to create an AWS DMS migration task:

  • Create a source endpoint, a target endpoint, and a replication instance before you create a migration task.

  • Select a migration method:

    • Migrating Data to the Target Database – This process creates files or tables in the target database, automatically defines the metadata that is required at the target, and populates the tables with data from the source. The data from the tables is loaded in parallel for improved efficiency. This process is the Migrate existing data option in the AWS console and is called Full Load in the API.

    • Capturing Changes During Migration – This process captures changes to the source database that occur while the data is being migrated from the source to the target. When the migration of the originally requested data has completed, the change data capture (CDC) process then applies the captured changes to the target database. Changes are captured and applied as units of single committed transactions, and several different target tables can be updated as a single source commit. This approach guarantees transactional integrity in the target database. This process is the Migrate existing data and replicate ongoing changes option in the AWS console and is called full-load-and-cdc in the API.

    • Replicating Only Data Changes on the Source Database – This process reads the recovery log file of the source database management system (DBMS) and groups together the entries for each transaction. If AWS DMS can't apply changes to the target within a reasonable time (for example, if the target is not accessible), AWS DMS buffers the changes on the replication server for as long as necessary. It doesn't reread the source DBMS logs, which can take a large amount of time. This process is the Replicate data changes only option in the AWS DMS console.

  • Determine how the task should handle large binary objects (LOBs) on the source. For more information, see Setting LOB Support for Source Databases in the AWS DMS task.

  • Specify migration task settings. These include setting up logging, specifying what data is written to the migration control table, how errors are handled, and other settings. For more information about task settings, see Specifying Task Settings for AWS Database Migration Service Tasks.

  • Set up table mapping to define rules to select and filter data that you are migrating. For more information about table mapping, see Using Table Mapping with an Task to Select and Filter Data