Case Study: a medical software provider achieves smooth SQL Server to Oracle migration with Ispirer Toolkit

Medical Software Provider migrates 24,000 LOC from SQL Server to Oracle with Ispirer Systems

A medical software provider based in Switzerland faced the challenge of migrating its extensive database from Microsoft SQL Server to Oracle. This involved automating the conversion of 1400 tables, hundreds of views, and thousands of lines of code in stored procedures, functions, and triggers. They needed a seamless way to transfer all business logic and data, so they engaged Ispirer Systems and used the Ispirer Toolkit.

Ispirer implemented a solution by customizing their SQLWays Wizard technology to fit the project's specific requirements, creating special conversion rules for the Oracle environment. The client was provided with a licensed, fully tailored migration tool and guide. The migration of 24,000 lines of code was completed smoothly over 12 months with full automation, eliminating any need for manual post-conversion coding. Ispirer also provided ongoing technical support throughout the process.

Medical Software Provider