This project is about migrating MSSQL 2019 DB to Oracle 19c DB on cloud. The data from MSSQL to Oracle had to be migrated without any transformation. The data was migrated with 100% accuracy between source and target. The go-live was done with minimal downtime which was within the scheduled maintenance window defined by the customer.
Number of databases on MSSQL Server: 10
Total number schemas involved for each DB: 1-3
Data Size: 4 TB
NicheSoft customized tools and scripts/automation, MYSQL Workbench, Streaming Technologies for realtime data migration, Data comparison tools, Schema conversion tools, Data migration tools.
A parallel environment was created for Development, QA, Staging and Production. Real-time streaming of data was enabled for staging and production environments. This enabled us to reduce the go-live downtime and perform the parallel environment testing with high accuracy levels. This also gave the customer a high degree of confidence to go-live with the new environment. This included functionality, performance, and data accuracy. Monitoring was enabled and validated for different scenarios before the go-live activity.
Password encryption methods used in source and targets
Native functions conversion
Character set used at database level
Data migration challenges
NicheSoft Benefits (Relevant for all the projects):
Successful completion of project within the scheduled timelines
Architectural and implementation expertise
Infrastructure and Environment details
Coding Standards followed across the project
Security standards followed at all levels
Data at rest
Data at transit
Post go-live production support