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

Oracle to PostgreSQL, Russia


Professional services of migrating Oracle packages and stored procedures to PostgreSQL.

Customer

At the end of 2016 Ispirer Systems carried out migration services for one of the Russian system integrators. The Company is one of the leaders that provides integrated technology and services solutions for financial industry. Among its clients are large banks, insurance companies, treasuries, other financial organizations.

Challenge

The Company was performing migration of Oracle database to PostgreSQL for one of its clients. To deliver the results within the tight deadline set by the Client the Company decided to partially delegate project implementation to an experienced partner.

As Ispirer Systems has great experience in successful migration projects implementation it has been involved in the project as a subcontractor.

Ispirer team concentrated on migration of more than 120 Oracle stored procedures with around 30 000 lines of code and several packages containing around 10 000 lines of code.

Solution

The migration stage of the Professional Services lasted for 4 weeks.

The optimal way of the migration services execution is by using Ispirer Migration and Modernization Toolkit (Ispirer MnMTK). As Ispirer MnMTK is a flexible tool, it can be quickly adjusted considering every source code peculiarities. Thorough source code analysis revealed the existence of some specific features in it. Ispirer team used different approaches for their conversion from Oracle to PostgreSQL.

1) The automatic conversion of the following statements was extended:

  • User defined types;
  • Oracle collections;
  • Global Package variables;
  • Hierarchical queries;
  • Pipelined functions.

2) The migration of some objects was executed manually:

  • PRAGMA AUTONOMOUS TRANSACTION;
  • DBMS_LOCK_ALLOCATED system table emulation.

3) The specific solution for emulation of work of DBMS_LOCK package through DBLINK extension was created.

The converted results were delivered in due time and successfully imported to the SQL objects of the target database PostgreSQL. The 6-week acceptance stage passed in a regular mode.

Results & Advantages

With the help of Ispirer Systems the Company could perform the entire migration on time. Ispirer had another chance to prove experience and competence of its experts.



Learn more about Ispirer's solution for Oracle to PostgreSQL Database 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.


PGDay.IT 2017
September 19, 2017 PGDay.IT 2017

We are happy to announce that Ispirer Systems will support the PGDay.IT 2017 that will be held on October 13th, 2017 in Milan, Italy.


Testimonials
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™...

...

October 3, 2017Staka Consulting, Iceland
DB2 LUW to PostgreSQL

"This summer Staka Consulting was looking for an efficient solution for porting DB2 database to Posgres database. We came accross Ispirer. Long story short, the project...

...

Feedback

It’s been pleasure that I found your tool for migrating Delphi to C#.NET. And I also see that it seamlessly migrates the Delphi features to C#.

Read more
Company News
Industry Events