Case Study Telecommunications · United States

Oracle to AlloyDB with Java app remediation — 12 weeks, end to end

Hughes Network Systems' ECOM platform — a 4.6 million line-of-code Java and NodeJS application — was fully migrated from Oracle to AlloyDB on Google Cloud in under 12 weeks, including schema conversion, data migration, and complete application remediation.

Oracle → AlloyDB Java · NodeJS 4.6M LOC Google Cloud Platform DMAP
4.6M
Lines of code migrated (Java + NodeJS)
12
Weeks from engagement to production cutover
4
Rigorous test environments before go-live
40+
Team members across 5 time zones

Hughes Network Systems, LLC is a Fortune 500 company and a recognized leader in networking technologies and services. Named a Leader in the 2023 Gartner® Magic Quadrant™ for Managed Network Services, Hughes enables essential connectivity for communities, businesses, and governments worldwide.

Hughes's ECOM platform is a business-critical application spanning 4.6 million lines of code in Java and NodeJS. Backed by Oracle databases, the system drives significant e-commerce operations and serves as a cornerstone of Hughes's digital infrastructure. Modernizing this platform to Google Cloud's AlloyDB was essential for long-term scalability and cost efficiency — but the complexity of the migration posed severe challenges.

Prior attempts at manual code conversion had already been made before Newt Global was engaged — yet the project remained stuck. Runtime failures caused by dynamic SQL and fundamental Oracle–PostgreSQL compatibility differences continued to block progress. The project needed a structured, systematic approach to overcome these barriers within a tight delivery window.

Key obstacles

  • Dynamic SQL in the application code resisted standard conversion tooling available in the market
  • Deep Oracle-specific constructs (procedural logic, data types, and SQL dialects) incompatible with PostgreSQL/AlloyDB
  • 4.6 million lines of Java and NodeJS code requiring systematic remediation at scale
  • 40+ team members spread across 5 time zones, demanding rigorous program management
  • No proven end-to-end toolchain existed for a migration of this scope and complexity

Newt Global was brought in during the last week of June 2024. The team immediately introduced the Cloud Migration Cockpit — a structured, transparent framework that provided a clear migration path with defined phases for database, data, and application conversion. This gave all 40+ team members across time zones a shared operational picture from day one.

I

DMAP-powered SQL conversion

Newt used DMAP to identify and convert unresolved dynamic SQLs within the application code — the core blocker that had stalled previous efforts. DMAP automated the conversion of remaining schema objects, eliminating manual guesswork.

II

DB schema & data migration validation

Database schema and data migration were validated end-to-end using DMAP's built-in validation framework, ensuring parity between Oracle and AlloyDB throughout the process.

III

Comprehensive cutover plan

The cutover strategy covered initial data load, Change Data Capture (CDC) for continuous sync, and Reverse CDC (rollback) capability — ensuring a safe, recoverable production transition with no data loss risk.

IV

Controlled program management

Focused governance on Go Live and Day 2 operations ensured a smooth transition. The team worked through weekends alongside Hughes's engineers to hit every milestone — adapting numerous interfaces and shell scripts for AlloyDB compatibility.

The Hughes ECOM application and its associated Oracle databases were seamlessly migrated to AlloyDB within 12 weeks — a timeline that many considered impossible given the scale and complexity of the system. The project was tested rigorously across four environments before production cutover, with all interfaces and shell scripts adapted for full AlloyDB compatibility.

12 wks
Full Oracle to AlloyDB production cutover, end to end
4.6M LOC
Java and NodeJS code successfully remediated and validated
4 envs
Rigorous pre-production testing environments validated before go-live
Zero
Data loss at cutover with CDC and Reverse CDC rollback safety net

The success of this first step — internally named TelecomVera — gave Hughes immense confidence in their ability to modernize further workloads on Google Cloud. The project set a new internal benchmark for enterprise Oracle migrations at scale.

Oracle Database AlloyDB for PostgreSQL Java NodeJS DMAP Cloud Migration Cockpit CDC (Change Data Capture) Reverse CDC Google Cloud Platform
"The team demonstrated their competence and commitment by working through weekends alongside our teams, helping us conquer what felt like Mount Midoriyama. Each stage was like a Ninja challenge, as we were all navigating it for the first time. DMAP achieved something no other tool in the market was doing."
MM
Mridul Malayanil
Senior Director – Cloud Solutions, Hughes Network Systems

More case studies

Telecommunications

Hughes: Oracle to AlloyDB — Striim reverse CDC for 9 countries

1.8 TB · 9 Countries · Cutover time: 14 hrs → 3 hrs

Read case study →
Airlines

LATAM Airlines: Oracle to Cloud SQL PostgreSQL via DMAP

17 TB → 7 TB · 98% automation · 10M+ Java LOC

Read case study →