Summary

  • Customer: IT and Communication Services Provider
  • Country: South Africa
  • Product Used: Ispirer MnMTK License
  • Source Technology: Sybase ASE
  • Target Technology: DB2
  • Project Scope: 700,000 LOCs
  • Project Duration: 2014-2015

Customer

A company, founded over 20 years ago in South Africa, provides services in the information technology and communication fields. They assist their clients in database and mobile platform management by introducing technology innovations into work products. The company uses technologies from such global developers as SAP and IBM in their solutions.

Challenge

The goal of this project was to find a solution for automated migration of the Sybase Adaptive Server Enterprise database to DB2.

Solution

During the Extension Stage, Ispirer Migration and Modernization Toolkit was developed by adding some specific conversion rules. “The knowledge of how database objects of different types are supposed to behave in target environment turned out to be extremely helpful”, said Pavel Leonov, Senior Database Migration Expert at Ispirer.

Summarizing the results, the software was fully tested to meet all the project requirements and delivered to the customer. The company acquired the Ispirer MnMTK license for six months that included free technical support from Ispirer migration experts assigned to the project. The volume of the legacy Sybase ASE database involved 100 triggers, 5,000 views and around 3,000 stored procedures. The overall size of the project was almost 700,000 lines of code.

Benefits Derived from Conversion

Additional customization of MnMTK ensured up to 100% of automated migration and excluded any manual efforts. The process of moving from Sybase ASE to DB2 was simple with the help of Ispirer MnMTK. The Ispirer professionals provided assistance in all the stages of the project, including post-migration period.