If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution.
AWS Database Migration Service simplifies migrations by managing administrative tasks, focusing on logic and functionality. It offers scalability and stability, supporting large-scale data efficiently with features like Change Data Capture and real-time synchronization. Integration with ETL tools and networking like VPCs is valued, though latency and data type conversion need improvements. Cost competitiveness and service integration for non-AWS environments are challenges, alongside the need for better technical support and transparency.