According to a development operations director at a healthcare firm, “With the use of the free tool, the migration effort took 50% less time but we had to hire a big team for data verification and code conversion. This impacts our timelines and creates a risk for successful project completion.” That equates to some cost savings in terms of data migration, but now they are spending time and money on the data verification and code conversion which could have been saved by Investing in a premium tool beforehand. That’s what I like about Traferium – all these tasks are automated.
Time and Cost Savings with a Migration Tool. Experience Matters.
In my experience, enterprises get stuck in the initial cost of the migration tool and fail to see the bigger picture.
Recent feedback from a manual migration team of 4 Subject Matter Experts/Developers revealed that the manual migration of 20 stored procedures and functions written in PL/SQL to Snowflake javascript would take 9 months for the code conversion alone. Additionally, they had to work on writing the scripts for schema mapping and data migration which added a couple of months to the manual migration effort total duration of the migration project was 12 months.
For the same project, Traferium would take 3 months. How’s that possible? Manual migration involves onboarding and training time, creation of scripts for manual migration, writing code for the conversion of PL/SQL to Snowflake JavaScript, and data validation. Traferium automates the discovery, schema mapping, data migration, job creation, reporting, code conversion, and many other steps which saves countless hours as compared to manual migration.
Reducing the duration of the project is only one of the ways that Traferium provides ROI. Other ROI factors include:
- 65% Reduction in Level of Effort in code conversion compared to manual migration
- 3X faster migration
As seen in the graphic below, there are several factors that add cost to a migration project. However, it shows how simply reducing the duration of a migration project significantly affects those costs. The image doesn’t capture all the different types of project costs that contribute to the total cost of operation (TCO) of a migration project.