From On-Prem to Next-Gen with Cloud Migration Factory
For over 55 years, a multi-billion-dollar financial firm has been a trusted financial services provider for countless individuals, corporations and municipalities. With over 3,000 locations, the firm is one of the largest financial firms in the United States and an industry leader for wealth management services.
To overcome speed, storage and security limitations of its onpremises databases, the firm decided to migrate its business unit’s desktop application — a portfolio management system that allows financial advisors to store, evaluate and monitor bond performance for clients — to the cloud. Leveraging AgileThought’s Cloud Migration Factory service, the firm partnered with AgileThought to migrate its on-prem SQL Server 2008 workloads to Azure SQL database — Microsoft’s modern, scalable and fully managed cloud database service.
- On-premises SQL Servers were unscalable, quickly outgrown by the business unit and unable to support large volumes of data.
- Lack of data storage and partitioning led to slow, oversized databases, hindering the business unit’s ability to manage and rapidly access mission-critical bond data.
- Strict regulations and challenges with meeting database infrastructure demands reduced the business unit’s speed to market.
Paving the Path to Database Modernization
As part of the Cloud Migration Factory service — AgileThought’s prescriptive methodology for assessing, optimizing, and migrating applications and databases running on SQL Server 2008 to Microsoft’s Azure cloud platform — AgileThought created a roadmap with complete visibility into the migration process to minimize business risk and disruption. Due to the highly confidential nature of the data, AgileThought also partnered with the firm’s corporate IT group to ensure the migration roadmap met all corporate security mandates.
While working with the firm’s corporate IT group, AgileThought also prototyped all application code changes that would need to be made to fully leverage the new cloud database. After the application was updated, AgileThought migrated all of the SQL Server 2008 databases that supported the business unit to Azure SQL database — a transition that provided the flexibility, speed and modernization that the team needed to remain competitive.
Boosting Team Autonomy and Speed
The success of the migration, coupled with AgileThought’s ongoing guidance and deep Azure knowledge, has given the business unit the autonomy to scale, make application updates and add new application features as needed.
Additionally, AgileThought helped the firm implement a partitioning strategy to reduce the size of its database and optimize it for growth. Due to their larger size, the previous databases struggled with slow query speed; by implementing a partitioning strategy, which splits the new database into multiple smaller databases, AgileThought helped the firm gain rapid access to data and create additional space for long-term growth.
Outpacing the Competition
AgileThought partnered with the firm’s business unit to migrate its entire application to the cloud without disrupting application uptime. Now, the application — which maintained its user experience — offers optimal speed and a greater competitive advantage to its end users. The firm’s financial advisors can access data faster, allowing them to outpace competitors by being the first to relay critical bond performance data back to clients.