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

 
Percona Live Europe 2017
August 31, 2017 Percona Live Europe 2017

We're excited to announce that Ispirer Systems will sponsor the Percona Live Open Source Database Conference Europe 2017 on September 25 - 27 in Dublin, Ireland.


Testimonials
August 22, 2017Cardtek, Turkey
Microsoft SQL Server to Oracle

"Cardtek is the most valuable company of Turkish finance and banking sector. Among other numerous projects, we are operating an end-to-end electronic fare...

...

August 21, 2017Caxton & CTP Publishers and Printers Ltd, South Africa
Sybase ASE to MySQL

"Dear Vera,

Where we are is as follows:

1. We have enabled all our software to operate in an 'Agnostic Manner' in that it is no longer hardware and database type...

...

Feedback

We have successfully migrated the database. Definitely, for any similar upcoming project, choosing Ispirer's tool would be the fastest way to succeed from my point of view.

Read more
Company News
September 19, 2017PGDay.IT 2017
September 13, 2017Happy Programmers' Day!
August 31, 2017Percona Live Europe 2017
Industry Events