Case Studies

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


Our solution

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


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

We run all kinds of DBA services that vow your success