DATABASE MANAGEMENT CASE STUDY

VisionAST Transitions from
Microsoft SQL Server to Amazon Aurora

VisionAST Is a Data-Driven Analytics Platform
to Improve Financial Performance

VisionAST is a SaaS platform that serves the auto, powersports, marine, and RV industries. Through real-time dealer management system (DMS) integration, VisionAST provides dealership decision-makers actionable fixed and variable operations data to more effectively drive service, parts, sales and finance & insurance profits. After a decade of change and growth, VisionAST and the Webapper team identified growing technical debt with the underlying database of the system. Performance bottlenecks and licensing costs loomed.

The goal became clear: migrate database services from Microsoft SQL Server running on Amazon on EC2 to AWS Aurora MySQL. The project plan included migration, extensive testing, and performance validation phases to ensure enhanced performance, scalability, and operational efficiency – with minimal disruption. It also included setting up the environment, migrating data, updating configurations, and thorough testing to confirm that the new system meets operational requirements and performance benchmarks.

The Impact

VisionAST’s database migration from Microsoft SQL Server to Amazon Aurora MySQL addresses performance issues, scalability concerns, and high licensing costs. The database migration was the second biggest update in the history of the platform, coming in second only to the initial launch in 2014. The results were
impressive – core reports now run up to four times faster, enhancing user experience and satisfaction. The new system also o ers better reliability, automated backups, and reduced administrative overhead. This migration positions VisionAST for future growth and improved customer service.

Get the Database Migration Case Study.