Data Migration

Cloud Data Migration from Oracle to Azure SQL Data Warehouse

One of the largest Media and Publication corporations with holdings in newspaper, magazine, radio and web channels across the United States with large customer base had a requirement to move their entire EDW data from Oracle to Azure SQL Data warehouse.

Client Challenges and Requirements

About 600 tables, 450 stored procedures, 120 functions and 50 User define types over all 115,000 lines of code to Migrate on Azure SQL Data warehouse in short span of time. Challenge is to handle

  • Data type Matching (Date time, Varchar)
  • Dynamic SQL
  • Nested PL/SQL Subprograms
  • User Define Functions

Bitwise Solution

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

Mapped Oracle schema with Azure SQL Data warehouse and auto converted DDL through SQL Server Migration Assistant

Implemented auto scheduling for timely execution of Database Migration through Bitwise Cloud Data Migration Framework

Daily Database sync-up using CDC with Bitwise Cloud Data Migration Framework

Automated Data Validation with full and sample validations with Bitwise Cloud Data Migration Framework

Handled sensitive data with tokenization through Bitwise Cloud Data Migration Framework

Provided ability to monitor the data migration process to check the progress/status with user friendly dashboards and reports through Azure Monitor and Application Insights

Tools & Technologies We Used

SSMA
Oracle
Bitwise Cloud Data Migration Framework
Azure Monitor
Application Insights

Key Results

Seamless Migration

Full Data Validation

35% Efforts saving in data Validation

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?