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 Validation Framework
Azure Monitor
Application Insights
Key Results
Seamless Migration
Full Data Validation
35% Efforts saving in data Validation
