Customer

Our Singapore client specializes in development of financial IT systems. The company provides solutions for stock breaking and assets administration firms. The range of their quality services include development of audit reporting, investment management and risk based capital systems.

Technologies

Microsoft SQL Server, Oracle

Challenge

The company had taken decision to change their database management system for internal reasons and selected Oracle. The client wanted us to provide the solution to migrate schema and more than 32 thousand lines of code Transact SQL.

Solution

Prior to initiate the Toolkit customization, Ispirer developers had evaluated the source database and the requirements to the target code. The migration project was quite massive and a series of additional developments were required to reach fully automated migration of all the database objects.

On customization phase, the migration Toolkit was tuned up in such a way that all the tables, views, stored procedures and functions could be automatically transferred to Oracle without compromising on functionality. Then the Ispirer MnMTK 2015 was licensed to the client and delivered ready to use.

Results and Advantages

The primary advantage of the solution proposed was the possibility of automating the migration process, which allowed avoiding product customization with each of the databases and of course manual conversion.

In the issuance, 32 thousand lines of code of business logic was migrated with the help of Ispirer MnMTK 2015 in less than one month. Ispirer developers made it possible to complete such a massive project on time.

2014