In the planning phase, SCT can be used to move the schema first by converting objects automatically. Several non-convertible objects will be manually rewritten by a DBA, with the detailed recommendations provided by the migration assessment report:
In the execution phase, the retrieval and copy of continuous data can be done directly by DMS; this copy can be paused and resumed at any time, and it is also fault-tolerant, as shown in the following diagram:
The heterogeneous target can also be configured to the following destinations, and you can leverage different patterns for storing and accessing your data:
- S3
- Aurora
- DynamoDB
- Redshift