A solution architect is planning a database migration from an Oracle database to Amazon Aurora with PostgreSQL.
During the planning phase, the solution architect would like to perform an assessment of migration complexity and size and identify any proprietary technology that would require database and application modifications.
What service can help the solution architect develop this assessment report and provide recommendations on migration strategies and tools?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
Option A is incorrect because AWS DMS is a tool that performs data migration during a database migration process.
Option B is incorrect because AWS SCT is a tool for accessing schema conversion and converting existing database schema from one database engine to another.
Option C is CORRECT because AWS Workload Qualification Framework (AWS WQF) is a standalone tool that is used during the database migration planning phase to assess migration workloads.
It produces an assessment report detailing migration complexity and size and provides migration strategy and tool recommendations.
Option D is incorrect because AWS DataSync is a data migration service for transferring data from on-premises file storage sources to AWS services such as S3 and EFS.
Reference:
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP-WQF.htmlThe service that can help the solution architect develop an assessment report for the database migration and provide recommendations on migration strategies and tools is AWS SCT (AWS Schema Conversion Tool).
AWS SCT is a free tool provided by Amazon Web Services that helps to convert a source database schema and code to a format that is compatible with a target database. In this case, the source database is an Oracle database, and the target database is Amazon Aurora with PostgreSQL. AWS SCT can perform a comprehensive assessment of the source database to provide recommendations on migration strategies, including the complexity and size of the migration and any proprietary technology that would require database and application modifications.
AWS SCT can perform a database schema conversion, a data migration, and a code conversion. The database schema conversion involves converting the Oracle database schema to the Amazon Aurora with PostgreSQL database schema. The data migration involves migrating the data from the Oracle database to the Amazon Aurora with PostgreSQL database. The code conversion involves converting the application code that interacts with the Oracle database to a format that is compatible with the Amazon Aurora with PostgreSQL database.
During the assessment phase, AWS SCT can analyze the Oracle database and provide recommendations on the best migration strategy, including identifying any proprietary technology that would require database and application modifications. AWS SCT can also provide recommendations on the best tools to use for the migration, such as AWS DMS (AWS Database Migration Service) or AWS DataSync.
In summary, AWS SCT is a free tool provided by Amazon Web Services that can help solution architects to develop an assessment report for database migration, including recommendations on migration strategies, tools, and any proprietary technology that would require modifications.