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

PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

Customer

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was Ispirer’s second assignment with the client.

Challenge

The client had initially contacted Ispirer to migrate a database from PostgreSQL to Oracle (PostgreSQL to Oracle Migration, United States). While processing the PostgreSQL database, the client was using test cases written in Java, which were to be used in the Oracle database. After realizing that migrating embedded SQL was quite a challenge, the client decided to summon Ispirer again to perform this migration. The total scope covered about 38 thousand lines of code.

Solution

All technical questions regarding the migration process, along with marketing-related queries, were discussed and answered during pre-sales. In line with the customer’s needs, the Ispirer team was able to offer an optimal migration solution, including analysis and resolution of issues that depended on database design.

Results & Advantages

The technical specialists completed the migration in two months. One of the greatest advantages of the proposed solution was the possibility of automating the migration process in order to minimize manual interventions as well as product customization efforts with each database. Yet again, Ispirer successfully demonstrated the efficiency of the SQLWays tool to the client.

2013



Learn more about PostgreSQL to Oracle migration

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


Testimonials
October 18, 2017Sociedade Bíblica do Brasil (SBB), Brazil
Visual Basic to Java Swing

"SBB is brazilian non-profit organization dedicated to spreading the Holy Bible and, through it, promoting the integral development of the human being.

We are...

...

October 11, 2017IT SOFTWARE, Italy
Microsoft SQL Server to MySQL

"IT SOFTWARE is focused on delivering cutting edge solutions for order-handling, pre-trade risk and market data to and for Global Markets.

Our Easy Trade™...

...

Feedback

I have been able to install the tool, and I must say that it has been one of the best I have found on the Internet. For the moment I’ve learned to manage the tool well.

Read more
Company News
Industry Events