Summary
- Customer: HR solution provider
- Country: United States
- Product Used: Ispirer Toolkit License
- Source Technology: Informix 4GL
- Target Technology: Microsoft SQL Server T-SQL
- Project Scope: 250,000 LOC
- Project Duration: 2017-2018
Customer
A trusted advisor to America’s best businesses has more than 2,700 corporate employees in 60 offices across the United States. Company offerings include Payroll and Human Capital Management, Time and Attendance, Performance Management, Organizational Planning, Recruiting Services, Employment Screening, Financial Services, Expense Management, Retirement Services and Insurance Services.
Challenge
The customer needed to modernize their critical internal software, in other words to perform migration of their Informix 4GL code to Microsoft SQL Server stored procedures. Ispirer nGLFly Wizard, part of Ispirer Toolkit, was chosen to handle automated cross-platform application migration in this project.
Solution
During the Analysis Stage, the Ispirer and customer’s teams discussed the requirements and found out the appropriate solution to migrate Informix 4GL code to MS SQL Server.
To check the chosen migration solution, the Ispirer team offered to perform a Proof-of-Concept stage. During the PoC, Ispirer team migrated 4,000 lines of Informix 4GL code to Microsoft SQL Server Transact-SQL. Based on the PoC results, Ispirer forecasted a high percentage of migration automation.
During the Extension Stage, the Ispirer team automated the developed solution for conversion of 30,000 lines of Informix 4GL code to SQL Server.
Benefits Derived from Conversion
The Ispirer team completed the Analysis, PoC and Extension Stages and achieved 90% of migration automation.
The customer has acquired the Ispirer Toolkit license for 6 months to convert 250,000 lines of Informix 4GL code to SQL Server.