Project Description:
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.
Project Details:
Number of databases on MSSQL Server: 10
Total number schemas involved for each DB: 1-3
Data Size: 4 TB
Tables: 1000+
Stored procedures:250+
Triggers: 100+
Functions: 100+
Project Duration:
4 months
Team size:
6 members
Tools used:
NicheSoft customized tools and scripts/automation, MYSQL Workbench, Streaming Technologies for realtime data migration, Data comparison tools, Schema conversion tools, Data migration tools.
Migration methodology:
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.
Challenges:
Password encryption methods used in source and targets
Security requirements
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
Capacity planning
Project planning
Agile methodology
Documentation:
Architecture details
Coding details
Infrastructure and Environment details
Runbooks
Handover document
Coding Standards followed across the project
Security standards followed at all levels
Data at rest
Data at transit
Post go-live production support
