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
July 25, 2017Open Business Solutions, United Kingdom
IBM DB2 AS/400 to Oracle

"We had a requirement to decommission an IBM AS400 for a customer and archive all the data to an Oracle Database. ...

June 24, 2017Kellenberger, Switzerland
Delphi to C#.NET

Dear Ms. Shavel

"I would gladly provide you with our experience with Ispirer conversion service. We had an old Borland Delphi 7.0 project, which was brought back to life. ...

Feedback

Testing for demo version has been successfully done, migrated all tables and data with total 2Gb.

Read more
Company News
Industry Events