Summary

  • Customer: Individual person
  • Country: Costa Rica
  • Product Used: Ispirer Toolkit License
  • Source Technology: InterBase
  • Target Technology: MySQL
  • Project Scope: 3,000 LOC
  • Project Duration: 2015

Customer

Our client was an individual from Costa Rica. He acquired a license for the use of Ispirer Toolkit in order to perform a database migration for business purposes.

Challenge

The task of Ispirer was to provide the customer with the most convenient solution for a database conversion from InterBase to MySQL. Our client needed a smooth and reliable migration preserving all of the needed business logic and data. The total volume of business logic and client’s data was almost 3 thousand lines of code. The database included many types of objects, notably, tables, triggers, sequences and stored procedures.

Solution

In order to accomplish this, Ispirer developers added the appropriate migration rules into Ispirer SQLWays Wizard. The client was licensed for one month with the software ready for migration process. Ispirer expert had demonstrated to the user how the Toolkit is working during training conference via WebEx. After that, the client was able to launch the toolkit and start to migrate his business logic into target environment without hiccups.

Results and Advantages

Automated database migration from InterBase to MySQL was completed on schedule. Due to professional improvement and customization prior to licensing, the client got correctly migrated MySQL code, which required no manual rewriting. The client’s concern was the risk of data loss, but the client’s data was retained in its entirety.