Customer

An India-based established provider of IT services solutions wanted to execute a complementary migration task for one of its customers. The client’s business aids the performance of the public sector, manufacturing, and financial services through application development, and IT consulting and maintenance.

Technologies

PostgreSQL, Oracle

Challenge

The end-user found itself involved in highly complex situations, all of which were required to be managed in order to tackle the challenge of moving to the Oracle platform. The client was looking for a reliable fit-for-purpose tool to facilitate the migration process of the PostgreSQL database to Oracle. They contacted Ispirer to address issues pertaining to this massive migration. The overall scope of the project involved more than a hundred thousand lines of code. To achieve this objective, Ispirer engineers developed a route map.

Solution

Our engineers decided to adopt a project-based approach and introduced our best practices to facilitate the migration of numerous database objects – tables, procedures, functions, triggers, views, sequences, and thirty GB of data. We tailored the tool’s functions to the requirements of the project and licensed it to the client as “ready to implement.” In order to sustain the migration process performed by SQLWays, our consultants worked alongside with the client’s technicians. Since Ispirer engineers have a well-developed mechanism for migration from PostgreSQL to Oracle, migration of business logic was smooth.

Results and Advantages

The solution implemented by Ispirer enabled the client to perform a cohesive and successful operation. The project-based approach, underpinned by consistent business processes, offer the client full benefits of SQLWays. With the successful move to the new platform, the client’s services became more efficient and profitable, facilitating the best possible service to their esteemed customers.

2013