Logistics Giant Modernizes 700K LoC in 9 Mos with Automation

Client profile

Our customer is the world leading logistics provider that helps customers purchase and deliver their goods. The company provides integrated logistics solutions, management, and value-added services to enhance operational efficiency and quality. The company offers end-to-end logistics services, including warehousing, transportation, e-commerce fulfillment, packaging, and clinical logistics. Headquartered in Florida, the customer operates through a global network.

Objective

The customer needed to migrate business logic to the application layer with minimal human effort. Given the substantial project scope (700,000 LoC), key priorities included:

• Minimizing downtime during migration
• Reducing long-term maintenance costs
• Ensuring scalability for future growth

Challenge

Having business logic in the Oracle database made the client meet several challenges:

• High Maintenance Costs. Expensive licensing and specialized expertise required.
• Limited Scalability. Inability to efficiently scale the database to meet growing demands.
• Rigid Development. High costs and delays in developing new applications.
• Custom Database Complexity. Difficulties in maintaining and optimizing proprietary database logic.

Solution

Assessment Stage

The project commenced with a comprehensive analysis of the Oracle database using InsightWays, an automated assessment tool. The assessment provided a detailed report on:

• Database schema structure
• SQL objects and dependencies
• Embedded business logic

The findings indicated that 90% of the migration could be automated with tailored adjustments to SQLWays, significantly reducing manual effort and project duration.



Customization Stage

As one of the main requirements of our client was minimizing the downtime, Ispirer experts carried out several major customizations to speed up the conversion process:

• Optimized code conversion rules for Oracle-to-Java migration
• Enhanced automation to handle complex business logic
• Customized conversion of error handling and logging
• Integrated Proxy classes generation according to customer requirements
• Introduced base classes for beans and implemented inheritance from them.
• Integrated the use of base class methods for managing database connections and transactions.

Migration and Execution

With the customized SQLWays solution, the client successfully migrated 700,000 LoC with 91% automation. Ispirer’s engineering team provided continuous support throughout the process, resolving minor issues and ensuring a smooth transition.

Technologies

Oracle 19c, Java (Spring Boot, with integration of Spring Batch and Hibernate. AOP mechanisms with AspectJ.)

Benefits and Results

The collaboration with Ispirer led the customer to the following results:

• 91% automation rate in business logic migration
• 3-4x faster migration compared to manual efforts
• Reduced long-term costs by eliminating Oracle dependency
• Improved scalability for future application enhancements
• Minimal downtime, ensuring uninterrupted business operations

Let SQLWays handle the heavy lifting of your database migration, too. Book a demo today or try SQLWays for free and take the first step toward a faster, smarter, and more scalable data infrastructure!