Client Challenges and Requirements
- Data type Matching
- Materialized view
- Nested PL/SQL Subprograms
- User Define Functions
- Migration of 2+ TB data
Cloud Data Migration
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.
Full Data Validation
35% Efforts saving in data validation
All Rights Reserved @ Bitwise 2022