High Availability Systems Co. Ltd., Japan, Oracle to PostgreSQL

Oracle to PostgreSQL, Pro*C to ECPG

High Availability Systems Co. Ltd., Japan, Oracle to PostgreSQL

Yoshiro Suyama

Executive Officer

July 7, 2014

We have performed a migration project for one of the biggest IT companies in Japan headquartered in Tokyo. The project included migration of our client’s database from Oracle to PostgreSQL, a part of Java application with JDBC API from Oracle to PostgreSQL and part of Oracle Pro*C C++ application to PostgreSQL ECPG C++ application. The scope of this migration was quite massive and included conversion of database scripts, indexes, views, sequences, packages, functions, application files, about one hundred thousand lines of code all in all.

Within the framework of this project database conversion, application conversion and dynamic SQL conversion were required. The task has been resolved successfully with the help of the tool SQLWays due to several customizations, carried out by the Ispirer technical specialists. The main challenge of this very project were short timelines – about one month. Accordingly, the customer was very concerned about being able to realize the project in a timely fashion. In the end, our customer was able to successfully implement conversion results and complete migration project on time.

We are looking forward to working with Ispirer again because they have proved being reliable and highly qualified specialists.

Do you want to move from Oracle to PostgreSQL?

Let's do it together!

Learn more