Case Study: a financial consulting firm cuts migration costs by 65% with Ispirer Systems

a financial consulting firm cuts migration costs by 65% with Ispirer Systems

A financial consulting firm, a Colombian subsidiary of a global company, faced the complex challenge of migrating its entire database from Microsoft SQL Server to PostgreSQL. This large-scale project involved transferring 300 GB of data, 3,000 tables, and 815,000 lines of code, with the additional goal of moving its business logic from SQL Server to the Java application layer. The firm engaged Ispirer Systems to address this intricate modernization effort.

Ispirer implemented a customized version of its Ispirer Toolkit to automate the migration process. This solution successfully converted the firm's Transact-SQL code to Java and migrated the data to PostgreSQL, achieving 90% automation for the business logic migration. The results were significant, with the project cutting migration costs by 65% and accelerating the database migration process three times faster than a manual approach, according to Ispirer.