#TeamGeoPITS We just got featured on YourStory! Click here to read on ➔

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.

Requirements

Our solution

Requirement to migrate the SQL Server from 2000 to 2017 along with the legacy data and the ETL packages.
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.
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.
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.

We run all kinds of DBA services that vow your success