Case Study

Seamless Database Migration from Ingres to Oracle database for Elevated Performance and Security

Seamless Database Migration from Ingres to Oracle database for Elevated Performance and Security

Pages 4 Pages

A global leader in seamless payments sought to migrate from Ingres to Oracle to improve performance, security, and scalability. Aspire Systems conducted a detailed assessment and used HVR for real-time data replication, ensuring minimal downtime. Oracle schemas were designed to mirror Ingres, with C programs recompiled using Pro*C, data transfer optimized via SQL*Loader, and Uniface frontend integrated with Oracle. Unix was migrated from Suse to RedHat with updated shell scripts and CRON jobs. The new system achieved 1,000 transactions per second, enhanced security with HSM encryption, and simplified processes, delivering faster, more reliable payment handling.

Join for free to read