Customer

Ispirer has been working together with a Czech company that specializes in the development and installation of equipment for gastronomical services. Retail & hospitality business is aggressively developing and expanding in the Czech Republic and our client is one of the leading players in this sector.

Technologies

Sybase ASA, PostgreSQL

Challenge

The scope of database migration from Sybase ASA to PostgreSQL involved more than 200 thousand lines of code and included several thousand stored procedures and functions, as well as tables, views, user accounts, triggers, and user-defined types. Adding to the challenge were the several objects with references to each other.

Solution

Having purchased a two-year license for SQLWays, the client utilized our migration tool for performing a massive database migration. After customizing the tool, the client was provided with SQLWays, meeting the requirements for the targeted PostgreSQL code. To ensure that each of the numerous Sybase ASA database objects was correctly converted into the targeted database, the parties agreed that, for the duration of the licensing period, the license will also involve technical assistance by the Ispirer support team for the migration process.

Highly-competent SQLWays tool developers were assigned for the project to consult and provide support and tool customizations when required. Regular video conferences and online meetings enabled us to operate support requests successfully and helped our support team to maximize communication efficiency with the client. We received about four support requests per month. In particular, the Ispirer team worked on result-sets processing, automation of session variables, and conversion of built-in functions, as well as some specific issues pertaining to conversion of joins.

Results & Advantages

Owing to close collaboration with the client’s technical team, all problematic issues (there were around 130) were fixed during the support period and the client was able to finish the migration on time.

2013-2014