Solution Description
AWS Data
Pipeline
Process and move data (ETL) between S3, RDS, DynamoDB, EMR, On-premise data
Create complex data processing workloads (NOT for streaming data!)
AWS Database
Migration
Service
Migrate databases to AWS while keeping source databases operational
(AFTER MIGRATION) Keep databases in sync and pick right moment to switch
(Use case) Consolidate databases into one, Disaster Recovery, Standby Database
Preferred for homogeneous migrations
AWS Schema
Conversion Tool
Migrate database schema (views, stored procedures ...) to compatible targets
Features: SCT assessment report, Update source code (update embedded SQL in code),
Fan-in (multiple sources - single target),Fan-out (single source - multiple targets)
Preferred for schema conversion, large data warehouse workloads (RedShift)
AWS DataSync Transfer from on-premise file storage to S3, EFS or FSx for Windows
(Integration) Migrate data using DataSync and use AWS Storage Gateway for ongoing
updates from on-premises applications