Exam AWS Certified Database - Specialty topic 1 question 276 discussion

B. AWS DMS for data migration and AWS SCT for generating the converted code "AWS SCT will automatically assess and convert the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database. Any objects that cannot be automatically converted are clearly marked as action items with prescriptive instructions on how to convert, so that they can be manually converted to complete the migration. AWS SCT can also scan your application source codes for embedded SQL statements and convert them as part of a database-schema-conversion project. During this process, AWS SCT performs cloud-native code optimization by converting legacy Oracle and SQL Server functions to their equivalent AWS service, helping to modernize the applications at the same time of database migration. Once schema conversion is complete, it can help migrate data from a range of data warehouses to Amazon Redshift using built-in data migration agents." https://aws.amazon.com/dms/schema-conversion-tool/

B Using AWS DMS for data migration is a suitable approach as it can migrate data from Oracle to Aurora PostgreSQL with minimal downtime. However, it does not address the issue of converting the Oracle code to PostgreSQL. Using AWS SCT can help with the conversion of stored procedures and functions, as well as application source code with embedded SQL statements. AWS SCT also allows for customization and manual intervention where needed. It can generate the converted code and provide recommendations for any manual changes required.

B, but this is not SCS exam question

B is the right answer SCT doesn't migrate data

B is correct . SCT can not be used for migration , It helps to generate code for conversion of non compatible components / items .