LIRE-API & R2ST1 — Oracle → Aurora PostgreSQL
End-to-End Migration Feasibility Assessment. R2ST1 Oracle 19c EE (180.83 GB, REGI_OWNER schema) and LIRE-API Java 17 / Spring Boot 2.7.5 assessed for migration to Amazon Aurora PostgreSQL. Combined project: 22 pw standard · ~9 wks with AI.
Prepared by
Aedeon
DB Size
180.83 GB
R2ST1 · REGI_OWNER schema · 129 tables
Total Effort
22 pw
17 pw with AI assistance (~23% saving)
Java Source Files
671
LIRE-API · Spring Boot 2.7.5 · Java 17
Project Timeline
~12 wks
~9 wks with AI · parallel DB + App streams
SCT Actions
525
438/441 storage auto-convert (99.3%)
DB Risk Areas
20
5 HIGH · 11 MEDIUM · 4 LOW
App Findings
28
2 P0 blockers · 4 P1 critical · 6 P2
Team Size
8 people
1 DBA · 2 PG Dev · 1 Java Lead · 2 Java Dev · 1 QA · 1 PM
Database Verdict
R2ST1 · REGI_OWNER · Oracle 19c EE 19.9.0.0.0
Application Verdict
LIRE-API · NYT authentication service · Java 17 / Spring Boot 2.7.5
SCT Conversion Result
645 total objects analysed
Combined At-a-Glance Statistics
| DB Side | App Side | |
|---|---|---|
| DB / App name | R2ST1 / REGI_OWNER | LIRE-API |
| Oracle Version | Oracle 19c EE 19.9.0.0.0 | Java 17 · Spring Boot 2.7.5 |
| Size / Scope | 180.83 GB | 671 Java source files |
| Tables / Files affected | 129 tables | ~24 files |
| Storage auto-convert | 99.3% (438/441) | N/A |
| Code auto-convert | 60.8% (124/204) | N/A |
| Total SCT actions | 525 | 28 findings |
| Team effort | 7.5 pw (DB stream) | 7.0 pw (App stream) |
| Project timeline | ~12 wks standard · ~9 wks with AI | ~12 wks standard · ~9 wks with AI |
| Primary blocker | 305 TX-control violations (5034/5035) | 11 PL/SQL package call sites (R3) |
| Secondary blocker | 10 Scheduler jobs (non-convertible) | Error-code mapping — 12 files (R1) |
| Feasibility | FEASIBLE · MEDIUM EFFORT | FEASIBLE · MEDIUM EFFORT |