Cloud Data Migration

Data Migration on Azure SQL MI from Oracle

data-migration-from-teradata-to-snowflake
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

test (4)

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

code (1)

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

feature (1)

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

framework

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

synchronize (1)

Provided detailed report for data migration and validations.

Group 3

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
Group 3

Seamless Migration

code (1)

Full Data Validation

test (4)

35% Efforts saving in data validation

Share This Case Study

Share on linkedin
Share on twitter
Share on whatsapp
Share on telegram

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Cloud Data Migration

    Our ready-to-go Cloud Migration Roadmap helps guide you through your initiative for moving on-premise data to the cloud
    Ready to start a conversation?

    Share This Case Study

    Share on linkedin
    Share on twitter
    Share on whatsapp
    Share on telegram

    Download Case Study

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Automated ETL Migration

    Risk-free conversion and optimization of source ETL jobs to a target ETL tool with maximum automation

    Ready to start a conversation?