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

Sybase to PostgreSQL Migration, United States (including embedded SQL migration)

Customer

Our client was a U.S.-based broadcasting and cable company that develops contemporary and futuristic conditional access technologies, and supports infrastructure deployed by major operators worldwide.

Challenge

The challenge was to convert Application C from Sybase ESQL API to PostgreSQL ECPG API, including embedded SQL. The conversion included more than two hundred triggers and over three hundred stored procedures. The total scope included almost 50 thousand lines of code.

Solution

We were working with only part of the complete application, and thus had to create a test environment designed to verify the basic capabilities of converted objects before product completion and delivery.

Results & Advantages

The Ispirer team managed to finish the project within just three months. On top of that, we provided the client a three-month warranty.

Warranty Service

During the testing process, the client presented some additional requirements for the trigger migration that necessitated use of a C++ Library, made by the client, in the target. All the requirements were successfully accomplished, much to the satisfaction of the client.

2014



Learn more about Sybase to PostgreSQL Migration

 
Testimonials
May 24, 2017Tectra AS, Norway
Progress to MS SQL Server, Progress 4GL to ASP.NET

To whom it might concern.

"After over 20 years in use our Patient Journal System really needed an upgrade. The application is based on...

...

April 11, 2017Utah Department of Technology Services, United States
Informix to Oracle, United States

"To whom it may concern,

Recently we have faced the necessity to migrate over 50 databases from outdated Informix Servers to our new Oracle Server. The...

...

Feedback

There are blob objects in the table, and I did not know how to handle them. Thanks for the good product, in general the conversion process went perfectly.

Read more
Company News
Industry Events