AWS Database Migration Service

Generate a Database Migration Assessment Report

Question

What AWS service can be used to generate a database migration assessment report with recommendations regarding schema conversion, database object compatibility, and conversion effort estimates?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer: B.

Option A is incorrect because AWS Database Migration Service is used to perform data migration for compatible databases.

Option B is CORRECT because AWS Schema Conversion Tool (SCT) can be used to produce the database migration assessment report.

Option C is incorrect because AWS Migration Hub is a centralized place used to track the status and progress of cloud migration across multiple application migrations and migration tools.

Option D is incorrect because AWS Server Migration Service is used to migrate on-premises servers to AWS EC2 instances.

Reference:

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html

The correct answer is B. AWS SCT.

AWS SCT (AWS Schema Conversion Tool) is a service that helps automate database migrations. It analyzes the source database schema and provides recommendations on how to convert it to a compatible schema for the target database engine.

AWS SCT provides a database migration assessment report that outlines the schema conversion recommendations, database object compatibility, and conversion effort estimates. This report helps in planning and executing the migration with confidence.

AWS DMS (AWS Database Migration Service) is a fully managed service that enables homogeneous and heterogeneous database migrations. It can migrate data from one database to another, but it does not provide any assessment report or recommendations for schema conversion.

AWS Migration Hub provides a central place to track the status of application migrations across multiple AWS services. It does not provide any schema conversion recommendations.

AWS Server Migration Service is a service that helps migrate on-premises virtualized servers and physical servers to AWS. It does not provide any schema conversion recommendations.

In conclusion, AWS SCT is the appropriate service to use for generating a database migration assessment report with recommendations regarding schema conversion, database object compatibility, and conversion effort estimates.