"We greatly appreciate the work and support Softjourn has provided to Versapay. Their team is quick, asks the right questions, and maintains a positive approach throughout. Their deep domain knowledge and business-level insight enable them to spot potential issues early, ensuring the success of our projects."
Zero Downtime, Maximum Performance: Versapay's Smooth Database Migration
ABOUT THE CLIENT:
CHALLENGE
Versapay's database struggled with performance issues due to large data volumes, and a more efficient system was needed.
SOLUTION
Softjourn leveraged AWS Aurora and advanced migration techniques to enhance database performance without service disruption.
RESULTS
The successful database migration improved performance, scalability, and reduced costs, with minimal downtime.
About the Client
Versapay is a prominent financial technology company specializing in accounts receivable software. Their Accounts Receivable Efficiency Suite automates the invoice-to-cash process, facilitates B2B payments, and streamlines cash applications with AI. This extensive data handling necessitated a reliable and efficient database system.
Softjourn began working with Versapay in 2021, collaborating on various projects including automation testing and R&D initiatives.

The Challenge
Versapay faced significant challenges with their existing database, particularly in handling large volumes of data. Over the years, as they accumulated gigabytes of historical data, the database struggled with performance issues, especially when modifying columns, deleting large data segments, or executing complex queries.
Versapay required a solution that minimized downtime, migrated all existing information seamlessly, transformed schema on the fly, and allowed rollback in case of issues. The goal was to migrate to a more efficient database system without disrupting ongoing operations.

The Solution
Softjourn proposed migrating Versapay's database to a more robust system using AWS Aurora and the Database Migration Service (DMS). We began with a proof of concept, where our Solution Architect and Database Administrator evaluated the new system under various conditions to demonstrate its superior performance.
The migration process included:
- Architecture Planning: Detailed strategies were devised for minimal downtime and rollback capabilities to ensure a smooth migration.
- AWS Database Migration Service: We utilized DMS to migrate data while the original database remained operational, synchronizing updates between both systems.
- Schema Transformation: Managed schema changes on the fly, such as converting integer columns to big integers, supported by DMS.
- Cost Optimization: Initially, each test migration was costly. The team optimized costs by migrating only the first thousand rows of each table during tests.
- Comprehensive Testing: Rigorous testing and adjustments were made, resulting in a complete report, scripts, and instructions for Versapay to execute the migration independently.
Benefits
Softjourn’s meticulous planning and execution resulted in several key benefits for Versapay. The new system demonstrated significant performance improvements, handling large data volumes and complex queries more efficiently. The optimization of the test migration process also led to substantial cost savings.
Additionally, the new system offered better scalability and flexibility, supporting Versapay's future growth and data management needs.
By using AWS DMS, we minimized disruption to ongoing operations and ensured minimal downtime during the migration process. Our team provided Versapay with comprehensive documentation to enable the client to maintain and manage the new database system effectively.

Conclusion
The migration project was highly successful, resulting in improved database performance and maintainability for Versapay. Softjourn's expertise and meticulous planning ensured a smooth transition, meeting all the client's requirements and constraints.
This complex project provided valuable insights and experience in managing large-scale heterogeneous database migrations, reinforcing Softjourn's capabilities in delivering robust and efficient solutions.