Smart and Effective Solution to Assist Migration (SESAME)

The key challenge in data migration testing is to complete the backend testing (i.e. from Requirement analysis to reporting) for each release within one week. The one week timeline will remain constant even though the mapped entities are delivered in a progressive way to test. This warrants the identification of an optimized testing approach, wherein the execution can be completed with high quality in shorter time and with sufficient time for analyzing and reviewing pitfalls

Solution Proposed

Adopted a framework driven approach to execute all the SQL scripts. The benefits of this approach were: 1. End-to-end execution achieved through single click of a button 2. Flexible enough to accommodate the changes in scope 3. Enables for better failure analysis, as the first set of execution results are also automated 4. Maintenance of history of execution enables further quality analysis 5. Signification reduction in execution time (around 70%)
https://hexaware.com/