Blog

From Oracle License Audit to PostgreSQL Freedom: A Migration Success Story

Young business couple checking in at hotel and beautiful receptionist helping them

In short:

An unexpected Oracle license audit became the starting point for reconline’s successful Oracle to PostgreSQL migration. With support from Splendid Data, the Swiss hospitality technology company migrated its database and adapted its applications in just three months, gaining long-term freedom from Oracle licensing.

Are you also familiar with Oracle License Audits?

It was June 2019, reconline, a Swiss company, which had built its booking platform (CRS) entirely on an Oracle database. Reconline had undergone an Oracle license audit, and it turned out that in the past they had generated a report, which Oracle support told them to do, without warning them about the license violation. Reconline hadn’t used the report after the support case.

The result: a hefty bill from Oracle.

Exploring life beyond Oracle

That was when reconline began looking into how they could move away from Oracle and start using PostgreSQL, open source and no more licensing hassles.

Reconline approached Splendid Data to explore the options, including costs, for technically migrating their Oracle database to PostgreSQL. Using our specialized software (Cortex), we conducted an in-depth assessment, developed a migration plan, and provided a fixed-price quote.

In addition to migrating of the Oracle database, we obviously also had to address the applications (developed with .NET). Based on a workshop, we explained to reconline what the impact on the applications would be and how it needed to be modified so that it would run on a PostgreSQL database.

Three months to a successful Oracle exit

We then began working together, and about three months later, the migration from Oracle to PostgreSQL was completed, and the application had been adapted accordingly. reconline went live in early 2020; we minimized the cutover time and temporarily kept the Oracle environment in sync to allow for a potential failover. Everything went smoothly, and after a few weeks, the Oracle failover could be disabled, and reconline was completely free of Oracle.

A little catch-up: How is life after Oracle?

Now you’re probably wondering… what am I supposed to do with such an out-dated customer reference case?

Reconline and Splendid Data recently got in touch with each other. Naturally, we were curious to see if there would be any problems.

Then came the message from reconline…

“Don’t worry, we’re still happily running PostgreSQL! Probably the best technical decision made in the company’s history.”

We didn’t want to keep this last bit from you. Thanks to Pascal Maissen of reconline.

reconline, is a Swiss based company, helping independent hotels appearing on the world’s major travel platforms — Amadeus, Sabre, and Travelport — for more than 20 years. Today, more than 3,500 hotels in 125 countries rely on reconline to reach guests they would not reach through other booking channels.

Want to know more?