Summary

  • Customer: Provider of HR Solutions
  • Country: United States
  • Product Used: Ispirer MnMTK License
  • Source Technology: Informix 4GL
  • Target Technology: Microsoft SQL Server T-SQL
  • Project Scope: 250,000 LOCs
  • 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. For this project was chosen Ispirer Migration and Modernization Toolkit that provides automated database and application migration.

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 MnMTK License for 6 months to convert 250,000 lines of Informix 4GL code to SQL Server.