Oracle to Fabric Lakehouse

Split an Oracle workload into Spark SQL for relational objects and Python/PySpark for procedural code in Fabric Lakehouse.

Preview Listed in the current SQL Tran project wizard
This migration path is available as a preview. Translation coverage and target deployment features are still evolving, so start with an assessment of your own source, target, and version before planning the project.
1. Assess

See the real migration surface

SQL Tran parses the source, maps dependencies, measures translation coverage, and separates automatic work from objects that need review.

2. Relational

Translate schema and SQL

Oracle tables and views are emitted as Spark SQL for the Fabric Lakehouse relational plane.

3. Procedural

Move the code with intent

Procedures, functions, triggers, packages, and types are emitted as Python/PySpark code for the execution plane.

What this scenario exposes up front

  • Hybrid SQL-and-code target profile
  • Spark SQL relational output
  • Python/PySpark procedural output

Get SQL Tran today!

Ready to get started?