Customer

We performed the project for the local administration of a town in Saxony-Anhalt in Germany.

Technologies

IBM DB2 LUW, Microsoft SQL Server

Challenge

They needed to transfer their critical data from IBM DB2 LUW environment to Microsoft SQL Server. 27 GB of data, contained in 300 tables, had to be moved to the new database management system.

The goal of this project was to achieve an automated migration of data, freeing up human resources of both the client’s and Ispirer’s sides from manual tedious tasks.

Solution

To reach the highest level of automation by the Ispirer Migration and Modernization Toolkit 2015, Ispirer Toolkit developers introduced some minor extensions and new conversion rules into it, according to the specification provided from the client. Following successful testing process, the customized Toolkit ready to perform the migration was delivered to the client. No additional extension requests were required, since the migration went smoothly.

Results & Advantages

Customization of the Toolkit ensured a correct result in the shortest terms. The client’s data was transferred to SQL Server in several weeks. Engaging the Ispirer MnMTK 2015 to ensure an automated conversion was obviously a beneficial solution as it was much less expensive than manual conversion and resolved the time issue.

2014