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.
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
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.