From Sybase ASA to Oracle: How Automation Simplifies the Transition

Summary

Customer: computer technology company
Country: United States
Product Used: Ispirer Toolkit license
Source technology: Sybase ASA
Target technology: Oracle
Project scope: 360 000 Lines of SQL code
Project duration: 6 months

Client profile

The customer is a multinational computer technology company headquartered in the USA. The customer provides both cloud-based and application services like consulting, advanced support, and education services. They also provide hardware and software products, including operating systems, virtualization, storage, servers, and other hardware-related software.

The company is listed on Global 2000, Best World's Employers, and Top 100 Digital Companies.

Objective

In order to update the entire company's infrastructure, the customer wanted to eliminate the outdated databases and replace them with modern Oracle systems.

Challenge

The transition to Oracle was chosen based on several challenges that our client faced:

The outdated database was hindering business growth
The database could not handle the increasing workload effectively
Maintaining the legacy database had become financially unsustainable

Try Ispirer Toolkit to streamline database migration

Book a demo

Solution

Decision-making stage

The client was looking for the most efficient solution for migrating from Sybase ASA to Oracle. Since the client had enough resources for the migration, only a database migration tool was needed.

The most suitable tool was Ispirer Toolkit, since the Sybase ASA to Oracle direction is one of the most developed directions for automatic migration.

Migration stage

The Sybase ASA to Oracle migration direction is highly automated in Ispirer Toolkit. To improve the automation level even more, Ispirer experts made minor improvements to the tool to provide a maximum level of automatic conversion.

Two conversion adjustments played a pivotal role in improving the conversion quality:

Stored procedure declarations. Parameter migration enhancement in stored procedure declarations ensured the accuracy and reliability of critical business logic.
Schema exclusion in function calls. The exclusion of functional calls was essential to eliminate compatibility issues.

The improvements significantly accelerated the migration timeline and reduced manual effort to a minimum. The result? A significant boost in automation to the maximum. The customer migrated the Sybase ASA database smoothly, free from errors, and with absolute confidence in the process.