When migrating an Oracle database to Amazon Aurora PostgreSQL, which tool converts the schema and code that is needed because the database engines differ?
Selecting a tool that converts the schema in a heterogeneous database migration.
AWS Schema Conversion Tool
Correct. AWS SCT is a tool that converts schemas and code between different database engines. It supports the conversion work in a migration where the engine changes, such as Oracle to Aurora PostgreSQL. The actual data migration is done together with DMS.
AWS Database Migration Service (DMS)
AWS DMS is a service that replicates and migrates the actual data of a database.
In a migration where the engine differs, SCT to convert the schema and code is needed first, and the conversion itself is not the role of DMS, so it is incorrect. They are used together in the order SCT (conversion) then DMS (migration).
AWS Application Migration Service
AWS Application Migration Service (MGN) is a migration service that rehosts entire servers to AWS.
Its target is server-level relocation, and it is not a tool that performs schema and code conversion between different DB engines such as Oracle and PostgreSQL, so it is incorrect.
AWS Migration Hub
AWS Migration Hub is a dashboard that tracks and visualizes the progress of multiple migration projects in one place.
Its role is managing and tracking migrations, and it has no feature to convert schemas or application code, so it is incorrect.
'Between different engines' and 'schema conversion' point to AWS SCT. The actual data migration is DMS. For homogeneous engines, SCT is not needed and only DMS is used. The division of SCT (conversion) plus DMS (migration) is the key.