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

 
PgConf.Russia 2017
March 3, 2017 PgConf.Russia 2017

We are happy to announce that Ispirer Systems will take part in the International Conference PGConf.Russia 2017 that will be held on March 15-17, 2017 in Moscow.


Feedback

I must say that your tool is perfect, I used it only twice, once to test and the second time to do the final work. In less than two minutes I found the exact MSSQL database. If I would find myself again in a similar situation I would not hesitate to consider your other products.

Read more