DB

DBMigrateAIPro

Oracle → PostgreSQL migration in minutes.
Schema conversion · PL/SQL transpiler · Parallel bulk copy · CDC zero-downtime cutover.

99.7%

Schema conversion accuracy

87K

Rows/sec throughput

3 wks

Avg migration time

0

Data loss incidents

⚡ Zero-downtime cutover 🔒 Self-hosted · no cloud required 🗄️ v2.0 — Pro Edition

🗄️

Oracle 19c

HR Schema

🐘

PostgreSQL 16

Target DB

Step 1 — Connect source (Oracle) and target (PostgreSQL) by dragging nodes onto the canvas

Assessment Output — HR Schema

⚠️ Risk Assessment Report

📋

78 tables · 342 columns

Estimated migration time: ~2 hours at 8 workers

⚠️

3 XMLTYPE columns detected

HR.DOCS.XML_DATA → will map to JSONB

🔄

12 Oracle packages found

Will be flattened to PostgreSQL schema-namespaced functions

🔗

2 circular FK dependencies

EMPLOYEES ↔ DEPARTMENTS — will defer during load

✅

Supplemental logging: ENABLED

CDC streaming is ready for zero-downtime cutover

✅

16 sequences auto-detected

Will sync to correct nextval after migration

3 WARNINGS 2 READY 99.7% convertible

Rows / second

0

peak 87,241 rows/sec

Total rows migrated

0

0% complete

Overall progress

Elapsed: 0s · ETA: calculating...

Active tables

HR.EMPLOYEES HR.DEPARTMENTS SALES.ORDERS

● LIVE LOG

✓

Migration Complete

All rows matched · 0 errors

Total rows

4.2M

Row match

100%

Duration

48m

Errors

0

✓ Row counts match — all 78 tables

✓ Sequence sync complete

✓ FK constraints verified

TABLE-BY-TABLE COMPARISON

Table	Oracle rows	PostgreSQL rows	Match	Status

Current SCN

4,829,103

Events / sec

0

Lag

12ms

Total events replayed

0

✓ Databases in sync

CDC running since migration completed.
Application can safely cut over to PostgreSQL.
Lag: <20ms

🎯 Ready to cut over
Redirect app to PostgreSQL and stop CDC when ready.

LIVE EVENT STREAM Oracle LogMiner — poll interval 5s

        SCN
        OP
        TABLE
        PAYLOAD
      

✓

Migration Complete

Oracle 19c → PostgreSQL 16 · Zero downtime · Zero data loss

4.2M

Rows migrated

78

Tables

48min

Total time

87K/s

Peak throughput

100%

Row match

0

Errors

🗄️ Oracle 19c

──── CDC ──→

🐘 PostgreSQL 16

DBMigrateAIPro v2.0 · medaxai.com