Summary

  • Customer: power management company
  • Country: United States
  • Product Used: Migration service
  • Source technology: Oracle 19c Enterprise
  • Target technology: Azure SQL Database
  • Project scope: 76 tables, 15 000 LoC
  • Project duration: 1 month

Client profile

The customer is a power management company that provides energy-efficient electrical, hydraulic, and mechanical power solutions. The company's primary activities involve designing, developing, and selling energy-efficient products, technology, and services. The offerings help customers reliably and sustainably manage electrical, aerospace, hydraulic, and mechanical power. The customer serves companies in Europe, North America, Latin America, Asia Pacific, and the Middle East, with manufacturing facilities worldwide.

Objective

The cistomer needed a solution to migrate complex pl/SQL procedures to Azure SQL with minimum manual effort.

Challenge

The client faced several problems that created obstacles to business growth:

  • Oracle database hindered database scalability
  • Oracle had few opportunities for integration with other services, which hindered business development
  • Complex database management and insufficient speed of interaction with the database

Try Ispirer migration services to get most out of your migration

Book a demo


Solution

Decision-making stage

The company previously tried to migrate its database with another automated solution and had issues converting complex pl/SQL procedures and pl/SQL packages to Azure SQL. After comparing the conversion quality of SQLWays Wizard, the customer decided to start a migration project with us.

Migration stage

Application migration service

Ispirer migration service stands out from competitors by combining automation and the experts' domain expertise. Such an approach makes it possible to streamline the process to the full. This project was not an exception. Utilizing SQLWays Wizard allowed the team to complete the conversion within a month.
Migration from Oracle to Azure SQL involved several challenges that the Ispirer developers had to tackle. What were the challenges, and how did we solve them:

  • Conversion of complex types to MSSQL. The types had several levels of nesting, including table types. The solution? The most effective method was migration to JSON.
  • MSSQL does not have materialized views. Solution: Our developers created a table and an additional procedure that will fill/supplement this table on a schedule.
  • Numbering. The discrepancy was that the numbering of arrays in Oracle starts with 1, and in MSSQL, with 0

Testing stage

Ispirer experts ask clients to provide test cases for the most efficient testing process. However, not all migration projects require this. In this project, the testing phase was carried out internally by Ispirer experts.

How is the testing stage organized at Ispirer? We provide functional and performance testing. We define tests that will check that the data structure in Azure SQL is correctly mapped against the structure of the source database (Oracle in our case).

Try Ispirer migration services to get most out of your migration

Book a demo


Technologies

Oracle 19c, Azure SQL

Benefits and Results

The collaboration with Ispirer let the customer gain the following benefits:

  • 2x time faster migration of the database compared to manual effort.
  • Ability to take advantage of the cloud database.
  • Easier integration with third-party services and solutions.