Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Oracle to PostgreSQL Migration, Japan

Customer

In cooperation with our solution partner in Japan, Ispirer executed a short-term migration project for a subsidiary of a grand, reputed Tokyo-based telecommunications company. The subsidiary is one of the largest system integrators in the world.

Challenge

Our client wanted to migrate its database from Oracle to PostgreSQL, as well as part of Java application with JDBC API from Oracle to PostgreSQL, and part of Oracle Pro*C C++ application to the PostgreSQL ECPG C++ application. The scope of this migration was quite extensive and included conversion of database scripts, indexes, views, sequences, packages, functions, and application files – about 100 thousand lines of code overall. The main challenge of this project was the short timeline of about one month.

Solution

Ispirer provided the client with full-cycle conversion services with the SQLWays migration tool. A well-prepared team was engaged, which included database and application migration specialists, Java and C++ consultants, and SQLWays tool developers. A project manager from Ispirer and a quality assurance specialist from our solution partner were assigned as well.

Due to the time restrictions defined by the client, the work was divided into three streams – database conversion, application conversion, and dynamic SQL conversion. The migration project was a real workout for Ispirer’s technical specialists and entailed full commitment to the project as well as immediate settlement of problematic issues.

Results & Advantages

The database migration was seamless as the results obtained with the help of SQLWays were almost impeccable and did not require many corrections from database migration specialists. The most difficult task, however, was the migration of dynamic SQL which always requires a higher degree of effort due to the irregularity and complexity of the dynamic SQL code. In spite of the complexity, the task was executed successfully with the help of SQLWays, and several customizations of the tool were carried out by the Ispirer team. As a result, all migration tasks were resolved and the client got ready-to-implement conversion results on time, putting to rest the doubts raised by the client regarding the feasibility of the project at the beginning.

2012



Learn more about Oracle to PostgreSQL Migration

 
Testimonials
April 11, 2017Utah Department of Technology Services, United States
Informix to Oracle, United States

"To whom it may concern,

Recently we have faced the necessity to migrate over 50 databases from outdated Informix Servers to our new Oracle Server. The...

...

March 2, 2017NedGraphics, The Netherlands, Migration to C#.NET
C/C++, AutoLISP to C#.NET

"The Project was to migrate the application NedInfra from C/C++, AutoLISP to C#.NET. NedInfra Suite is an extensive add-on for AutoCAD (and AutoCAD Map and AutoCAD...

...

Feedback

Thank you for your prompt replies and support. I'll definitely suggest your migration software to any colleague faced with a similar task.

Read more
Company News
Industry Events