Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Microsoft SQL Server to Greenplum Migration, South Africa

Customer

Our Johannesburg-based client is one of the largest banks in South Africa. The bank has more than one thousand staffed branches in South Africa and maintains a substantial market share in business banking, property finance, investment banking, commercial finance, accepting deposits, acquiring cards, wealth management, and benefits management.

Challenge

The client, working with Ispirer’s technology partner EMC Greenplum, expressed a desire to use the Greenplum platform. Our partner recommended Ispirer’s migration services as the most efficient option for the client’s Microsoft SQL Server to Greenplum migration project. A large number of SQL scripts were to be migrated within a short timeline. The EMC team planned to work onsite and subcontracted Ispirer to provide the remote migration services.

Solution

Ispirer was working as part of the project team and chosen as a business logic service provider. The task entailed total involvement of our technical specialists and tool developers into the migration process. The key objective was to provide ready-to-implement conversion codes, so that the client would not have to deal with any issues after receiving the conversion results. Our technical specialists divided the working process into three parts – conversion of big-sized files, conversion of medium-sized files, and conversion of small-sized files, making the process well-structured and consistent. Ispirer’s automated migration tool SQLWays was used for migration. Some rapid replacements in the source code scripts were made and a few specific conversion rules were added into the tool.

Results & Advantages

Ispirer’s highly qualified and well-prepared team facilitated implementation of the migration project. The team managed to deliver the migrated code within two months, in line with the project schedule and budget.

2012



Learn more about Microsoft SQL Server to Greenplum Migration

 
Testimonials
January 2, 2017Wine & Vinos GmbH, Germany
Progress to Microsoft SQL Server

"We had to change our ERP System from an old one based on Progress Database. We chose Microsoft Dynamics NAV and had to migrate data from the old Progress...

...

November 29, 2016La Nacional Corp., United States
Sybase ASA to MS SQL Server

"We recognized the urgent need to perform the database migration from outdated Sybase ASA to Microsoft SQL Server. Having tried various migration options available...

...

Feedback

I just want to touch base with you to let you know that the tool is doing great work so far.

Read more
Company News
Industry Events