The client is a UK-based company and has custom application using Oracle 9i as the backend database. The customer needed to migrate its backend database to PostGres, an open source relational database to cut down the licensing and maintenance costs.

Savitr having a strong exposure in Oracle and Postgres was invited to port the data of this Oracle database which was over a gigabyte to postgres. The challenge faced by Savitr was that the Oracle database had over 60 tables, more than 60 stored procedures and over 100 triggers and there was minimal documentation available. Savitr’s team had to rely on their Oracle and Postgres skills so that the migration of data was smooth.

The datatypes, the extent of functionality available for stored procedures and triggers available in Oracle and Postgres were markedly different. Savitr’s team had to ensure that the target database was designed and data ported in a way to cause minimal impact to the frontend application. The team also had to rewrite all the stored procedures and triggers.