top of page
  • Writer's picturepuru Nichesoft

Migration of MSSQL DB to Oracle DB on cloud

Updated: May 9, 2023

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.



women standing in server room
data consultant


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




1 view0 comments
bottom of page