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
January 18, 2018SEA PRODUCTIQUE, France
InterBase 6.0 to Microsoft SQL Server

Within the framework of the factory's supervisory and information system updating project we were looking for a tool to migrate the existing "Interbase...

...

December 20, 2017BioSignals Ltd, Israel
SAP Sybase SQL ANYWHERE database migration to MSSQL

"In The last 2 weeks your company helps us to migrate a big Sybase SQL Anywhere database schema and content to MSSQL 2017.
Before we got...

...

Feedback

I have got your letter and the demo version. I tried it and it seems a very efficient and complex solution which is able to create oracle import scripts.

Read more
Company News
Industry Events