1. Create DB dms_pgsql_soure trong RDS
- Performance Insights Performance Insights enabled Turned on
- Tạo parameter group dms_parameter_group có cùng pgSql version, để khi tạo DB có thể chọn được
- set value cho dms_parameter_group
+ rds.logical_replication: 1
+ session_replication_role: replica
- table sync in DB have to primary key
2. Create DB Redshift tương tự ở trên
- After create Cluster, need create role dms-access-for-endpoint with policy: AmazonDMSRedshiftS3Role & AmazonRedshiftAllCommandsFullAccess
3. Create replication instance dms_replication
4. Create 02 endpoint from 02 DB
5. Create migration tasks: dms_task_migrate