Oracle Database to Azure Migration Center¶

The definitive resource for migrating from Oracle Database to Microsoft Azure -- whether displacing Oracle entirely with Azure SQL or PostgreSQL, or embracing Oracle Database@Azure for workloads that must remain on Oracle.

Who this is for¶

This migration center serves federal CIOs, CDOs, Chief Data Architects, database administrators, platform engineers, and application teams who are evaluating or executing a migration from Oracle Database to Azure-native managed databases. Whether you are responding to Oracle license renewal sticker shock, an open-source mandate, audit risk mitigation, or a strategic consolidation onto Azure, these resources provide the evidence, patterns, and step-by-step guidance to execute confidently.

Audience by role¶

Quick-start decision matrix¶

Target platform comparison¶

The first and most consequential decision is which Azure database platform to target. Oracle workloads typically land on one of four targets.

How CSA-in-a-Box fits¶

Regardless of which target database you choose, CSA-in-a-Box serves as the unified analytics, governance, and AI platform that consumes data from migrated Oracle workloads.

flowchart TB
    subgraph Oracle["Oracle Source Estate"]
        direction LR
        OLTP[OLTP Databases]
        DW[Data Warehouses]
        EBS[E-Business Suite]
    end

    subgraph Targets["Azure Database Tier"]
        direction LR
        SQL[Azure SQL MI]
        PG[Azure PostgreSQL]
        ORA[Oracle DB@Azure]
    end

    subgraph CSA["CSA-in-a-Box Platform"]
        direction TB
        subgraph Ingest["Ingestion Layer"]
            MIRROR[Fabric Mirroring]
            ADF_I[Azure Data Factory]
        end
        subgraph Lake["Lakehouse Layer"]
            ONELAKE[OneLake + Delta Lake]
            DBT[dbt Medallion Models]
        end
        subgraph Govern["Governance Layer"]
            PURVIEW[Microsoft Purview]
            CLASSIFY[Classifications + Lineage]
        end
        subgraph Serve["Serving Layer"]
            PBI[Power BI + Direct Lake]
            AIFD[Azure AI Foundry]
        end
    end

    OLTP --> SQL
    OLTP --> PG
    OLTP --> ORA
    DW --> SQL
    EBS --> SQL

    SQL --> MIRROR
    PG --> ADF_I
    ORA --> MIRROR

    MIRROR --> ONELAKE
    ADF_I --> ONELAKE
    ONELAKE --> DBT
    DBT --> PURVIEW
    PURVIEW --> CLASSIFY
    DBT --> PBI
    DBT --> AIFD

Key integration patterns:

• Fabric Mirroring replicates Azure SQL MI and Oracle DB@Azure tables to OneLake in near-real-time, enabling analytics without impacting transactional workloads
• Azure Data Factory pipelines in domains/shared/pipelines/adf/ orchestrate batch ingestion from PostgreSQL and other sources into the CSA-in-a-Box medallion architecture
• Microsoft Purview in csa_platform/csa_platform/governance/purview/ catalogs migrated databases, applies data classifications (PII, CUI, PHI), and maintains end-to-end lineage
• dbt models in domains/shared/dbt/ transform raw Oracle data through bronze/silver/gold layers with enforced contracts
• Power BI with Direct Lake serves analytics directly from OneLake with no data copy

Strategic resources¶

Documents providing the business case, cost analysis, and strategic framing for decision-makers.

Migration guides¶

Target-specific deep dives covering every aspect of an Oracle-to-Azure migration.

Tutorials¶

Hands-on, step-by-step walkthroughs for common migration scenarios.

Federal and government¶

Assessment and planning¶

Timeline expectations¶

Migration timelines depend heavily on Oracle estate complexity. These are representative ranges.

Navigation¶

By migration phase¶

1. Assess: Feature Mapping | TCO Analysis | Benchmarks
2. Plan: Migration Playbook | Best Practices | Federal Guide
3. Convert: Schema Migration | Azure SQL Migration | PostgreSQL Migration
4. Move: Data Migration | Security Migration
5. Validate: Benchmarks | Best Practices
6. Optimize: CSA-in-a-Box integration | Cost Management

By Oracle feature¶

Maintainers: csa-inabox core team Last updated: 2026-04-30