Oracle to Databricks

Split an Oracle workload into Spark SQL for data objects and Python/PySpark for procedural logic on Databricks.

Assess this scenario
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 translated into Spark SQL for the Databricks relational plane.

3. Procedural

Move the code with intent

Procedures, functions, triggers, packages, and types are translated into Python/PySpark for the code 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?