Requirements :

• • Requirement to migrate the SQL Server from 2000 to 2017 along with the legacy data and the ETL packages.
• • The client was constrained about the time taken to achieve the migration since an extensive downtime to achieve the process would not be possible, being a core banking operations software.

 
Our solution :

• • GeoPITS deployed their staged migration approach to first complete the ETL process, extensively test the packages on UAT and optimize the process to achieve the goal with minial downtime.
• • Migrated 345 ETL packages and 3.3 TB of data from 2000 to 2017

 

Benefits :

• • Achieved with 2 hours of minimal downtime
• • 5X faster SSIS package execution time achieved
• • Completed the whole enterprise DB migration in 5 months duration as planned.