A company wants to migrate its on-premises Microsoft SQL Server Enterprise edition database to AWS. The online application uses the database for transactions, and the data analysis team runs reports against the production database for analytics. The company wants to minimize operational overhead by using managed services where possible. Which solution will meet these requirements with the LEAST operational overhead?

Migrating to Amazon RDS for Microsoft SQL Server with read replicas offers the least operational overhead. RDS is a fully managed service, handling database provisioning, patching, backups, and scaling, which significantly reduces administrative tasks compared to managing SQL Server on EC2. Read replicas offload reporting queries from the primary transactional database, improving performance for both applications and analytics. Microsoft SQL Server on Amazon EC2 requires you to manage the operating system, SQL Server installation, and high availability features like Always On, leading to higher operational overhead. Amazon DynamoDB is a NoSQL database and is not a direct migration path for a relational Microsoft SQL Server database, requiring significant application re-architecture. Amazon Aurora MySQL is a MySQL-compatible relational database, not SQL Server, and would also necessitate a database engine change and application refactoring.