AWS Database Blog
Author: Vaibhav Sabharwal
Vaibhav Sabharwal is a Principal Solutions Architect at AWS based out of New York. He partners with customers to align cloud strategy with business outcomes, translating technical capabilities into measurable business value. His work spans cloud adoption strategy, AI/ML innovation, and operational excellence. He is an active member of the Financial Services and Storage Technical Field Communities at AWS, where he contributes to industry-wide best practices and thought leadership.
How Phreesia replicated a 30 TB SQL Server database to Amazon S3 with AWS DMS
In this post, we discuss how Phreesia used AWS DMS to replicate their on-premises database to AWS in an effective and cost-optimized manner. Because of the database’s large size and complex data structure, properly tuning the AWS DMS configuration was critical to minimize the migration duration and cost. We outline the fine-tuning techniques that were applied to optimize the AWS DMS task settings, instance size, IOPS provisioning, and table mappings. Applying these performance optimizations allowed Phreesia to develop a migration strategy to move this 30 TB database to Amazon S3 in just 2 days without disruption to production workloads.