A multinational RetailBanking company migrates from SQL 2000 to 2017 with minimal downtime
SQL Database Migration and ETL Development Seamless migration from SQL Server 2000 to 2017 with 5x faster SSIS Package Execution time
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.
.svg){kind=icon}
We run all kinds of database services that vow your success!!
