Trekport

May 3, 2026 · Trekport Team

Announcing Trekport — Oracle to PostgreSQL, done right

Trekport is a desktop application that migrates Oracle databases to PostgreSQL — schema conversion, PL/SQL translation, and data transfer in one place. No cloud uploads. No manual remediation.

Announcing Trekport — Oracle to PostgreSQL, done right

If you've ever migrated a real Oracle database to PostgreSQL, you know the truth that doesn't make it into vendor pitches: commercial tools plateau at 60–70% conversion. The other 30–40% — packages, compound triggers, dependency-ordered objects, grants, exception handling — gets dropped on a database engineer's desk to fix by hand. For weeks. Or months.

Trekport closes that gap.

Why we built it

We built Trekport because we lived this problem. Engineers spending entire quarters writing SQL by hand to clean up what AWS SCT or Ora2Pg left behind. Migration projects that ran 3× over schedule because nobody budgeted for the long tail of stubs and RETURN NULL placeholders. Cutovers that slipped because validation was an afterthought.

Our thesis was simple: if a tool can't deploy 100% of objects, it isn't a migration tool — it's a starter kit. So we built Trekport around a 100% deployment mandate.

What's different

AST-based, not regex-based

Most Oracle-to-Postgres tools use regex pattern matching. They work great on the easy 70% and fail unpredictably on the rest. Trekport parses Oracle SQL and PL/SQL into a syntax tree, transforms it, and emits PostgreSQL-native DDL and PL/pgSQL. Structural correctness, not pattern luck.

14-phase dependency-ordered deployment

Foreign keys before triggers. Triggers before materialized views. Sequences before tables that need them. Trekport orchestrates all 14 phases of a PostgreSQL deployment so circular references and ordering bugs don't torpedo your cutover.

Compatibility layer, not translation shims

Where PostgreSQL doesn't natively support an Oracle construct, Trekport ships standard extensions (orafce plus a few of our own) that provide the real implementations — DECODE, NVL, SYSDATE, DBMS_* packages, UTL_* functions. Your converted code runs unmodified.

Air-gapped by default

Trekport Studio runs entirely on your machine. No cloud uploads, no telemetry, no SaaS backend. Your Oracle credentials, source schemas, and migration output never leave your network. That makes it suitable for air-gapped, classified, and regulated environments.

What's in the box

Trekport Studio is a desktop application (macOS, Windows, Linux) that handles the full migration lifecycle:

  • Schema extraction (catalog introspection)
  • AST-based DDL conversion
  • PL/SQL → PL/pgSQL translation (packages, triggers, functions, procedures)
  • 14-phase dependency-ordered deployment to PostgreSQL
  • Parallel data transfer with backpressure
  • Row-count, type, and constraint validation
  • Exportable HTML and PDF migration reports

Supports Oracle 11g, 12c, 18c, 19c, 21c. Targets PostgreSQL 14+.

Pricing

We're launching with two tiers:

  • Studio — $49/mo. Individual DBAs and developers. Up to 50 GB data transfer. Schema conversion, PL/SQL translation, validation, reports.
  • Enterprise — $299/seat/mo. Teams running large-scale migrations. Unlimited data transfer, batch automation, custom type mappings, enterprise SSO, dedicated migration architect.

A free trial is available — up to 10 tables, full conversion and translation. No credit card required.

Try it

Download Trekport Studio. Or talk to us about your Oracle estate — we'll help you scope a migration plan.