Client Challenges and Requirements
- Data type Matching
- Materialized view
- Nested PL/SQL Subprograms
- User Define Functions
- Migration of 2+ TB data
Bitwise Solution
Thoroughly analyzed existing database system to Identify all components that must exist in target environment.
Mapped Oracle schema with Azure SQL MI and auto converted DDL through SQL Server Migration Assistant.
Implemented timely execution of Database Migration through SSMA and leveraged custom python utility for some of the DB object migration.
Automated Data Validation with full and sample validations with Python based data validation Bitwise accelerator.
Provided detailed report for data migration and validations.
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
Seamless Migration
Full Data Validation
35% Efforts saving in data validation
