Create Migration Task

Create Migration Task

Create a Database Migration Task

  • Go to DMS Console and select Database migration tasks
  • Click Create task Create Database Security Group

Task configuration

  • Task identifier: mysql-to-postgres-migration
  • Replication instance: migration-replication-instance
  • Source database endpoint: source-mysql-endpoint
  • Target database endpoint: target-postgres-endpoint
  • Migration type: Migrate existing data and replicate data changes Create Database Security Group

Task settings

  • Target table preparation mode: Drop tables on target
  • Include LOB columns in replication: Limited LOB mode
  • Max LOB size (KB): 32
  • Enable validation: Yes
  • Enable CloudWatch logs: Yes Create Database Security Group

Table mappings

  • Editing mode: Wizard
  • Click Add new selection rule and configure:
    • Schema: sampledb
    • Table name: %
    • Action: Include
  • Click Create task Create Database Security Group