We have an RDS instance and want to replicate the data of the tables in that RDS to multiple targets. Below are the requirements.
- Migrate data from source (RDS) to target (RDS).
- Migrate data from source (RDS) to target (Kinesis).
- Migrate data from source (RDS) to target (S3).
- Migrate data from source (RDS) to target (Open Search).
- Migrate data from source (RDS) to target (Redshift).
For all the migration tasks, the source is same but the targets are different. Can we do the above mentioned migration with single DMS task or do we have to create multiple DMS tasks by taking a hit on the RDS instance performance?