Data Migration

Data Migration on Azure SQL MI from Oracle

case-study-feature-img

As part of its cloud data warehouse initiative, a large research and advisory firm with global customer base needed to move their entire EDW data from Oracle to Azure SQL MI.

Client Challenges and Requirements

About 250 tables, 120 views, 40 materialized views to be migrated on Azure MI in short span of time. Challenge is to handle

  • Data type Matching
  • Materialized view
  • Nested PL/SQL Subprograms
  • User Define Functions
  • Migration of 2+ TB data

Bitwise Solution

solution-icon

Thoroughly analyzed existing database system to Identify all components that must exist in target environment.

solution-icon

Mapped Oracle schema with Azure SQL MI and auto converted DDL through SQL Server Migration Assistant.

solution-icon

Implemented timely execution of Database Migration through SSMA and leveraged custom python utility for some of the DB object migration.

solution-icon

Automated Data Validation with full and sample validations with Python based data validation Bitwise accelerator.

solution-icon

Provided detailed report for data migration and validations.

solution-icon

Suggested and implemented performance optimization by creating clustered index, non clustered index, performing table partitioning and altering table field sizing to save space.

Tools & Technologies We Used

SSIS
Oracle
SQL MI
Python
Power BI
Java- Spring, Spring Batch
Bitwise Cloud Data Migration Framework

Key Results

skill-icon

Seamless Migration

skill-icon

Full Data Validation

skill-icon

35% Efforts saving in data validation

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?