Question

A retail company is planning to migrate a 4 TB on-premises Microsoft SQL Server database to Amazon Aurora PostgreSQL. Before committing to the project timeline, the migration team needs a detailed report that quantifies how many database objects (stored procedures, triggers, functions, and views) can be converted automatically versus those requiring manual rework. Which approach provides this analysis with the LEAST effort before any data is moved?

Accepted Answer

Run the AWS Schema Conversion Tool (SCT) or DMS Schema Conversion to generate a database migration assessment report that categorizes objects by conversion complexity.

Answer

Start an AWS DMS full-load-and-CDC task and review the CloudWatch task metrics to identify objects that fail to replicate.

Answer

Use AWS Application Discovery Service agents on the database server to collect object-level conversion estimates.

Answer

Export the SQL Server schema with native tools and manually compare each object against PostgreSQL syntax documentation.