Oracle to Microsoft SQL Server, the Netherlands

Customer

A Dutch IT company whose products help to create and share digital design.

Challenge

The purpose of Ispirer in this project was to migrate the customer’s database from Oracle PL/SQL to Microsoft SQL Server T-SQL. The company needed to move their critical database in an extremely short period of time in a few months. Since the technical team of the customer had almost no experience with Microsoft SQL Server, they relied entirely on Ispirer knowledge.

Solution

The project's goal was to transfer more than 150,000 lines of code contained in 200 packages to the environment of SQL Server.

An initial version of the migration software was provided to the customer, demonstrating high functionality when migrating the code. The functionality of Ispirer Toolkit has been improved as a result of further development and customization. Due to the exceptional flexibility of the Ispirer tool, it was customized to the customer’s project during the support stage.

The Ispirer team completed additional works: peculiarity of the source code were Oracle geometrical objects, namely packages (SDO_UTIL, MDSYS, SDO_GEOM) and xml. Working with xml was possible thanks to the use of such methods as xmltable, XMLNAMESPACES, xmlelement, xmlagg, XMLFOREST. As a result, specific migration rules were successfully developed and added to the Ispirer software.

Benefits Derived from Conversion

In this project, the timing was crucial for the customer, and the Ispirer team successfully handled the migration task. Ispirer Toolkit has been extended and prepared particularly for this migration, taking into account the specific migration rules that were necessary for the correct conversion of objects to the target platform.

Our client was satisfied with our approach and the ease of use of the Ispirer tool. Ispirer delivered a product that showed a high level of database migration automation and excellent results.