AWS Database Migration Service

Heterogenous Migration

===

offline migration- take db back up and recreate db in cloud

online migration - DMS support it for the application which is reading/writing to db and at the same time copy data to cloud db.

source db on ec2 instance

==

create target db-aurora mysl instance in aws

conenct to source db mysql as below

create db script to prepare this db as source db for the migration as below

execute above script to prepare db as source db for the migration.

Download and install AWS SCT

Use my sql workbanch and create target db instace connection with aurora writer endpoint as below

open taregt db conenction and in query editor , provide certain permision to execute script in target db as below

open SCT and enter details as below

conenct to source db as below with required driver

choose scema

This will perform dm migration assesment and provide the report for the same.

choose target db

will present action items which indicate

1- can be taken care

2. need manual intervention

seldct sample and convert schema

select target sample and right click- applyu to database

above steps conclude schema migration.

now we will perform data migration

connect to target db instance in my sql workbench and open query editor

drop forien key or indexex so that data copy process run smoothly.

then we will update contraint again.

Goto AWS cosole ->DMS-> migration data->replication instance-create it

once it is created , create endpoint for source db and target db as below

source endpoint and target endpoint created

now we create database migration task

===