Mohit Nanda and Amol Khanapurkar, Tata Consultancy Services Ltd - Mumbai, India

Across the various RDBMS vendors Oracle has more than 60% [6] of market share, with a complete feature-rich and secure offering. This has made Oracle as default choice as the database choice for systems of all sizes. There many open source databases as MySQL, PostgreS, etc. which has now evolved into complete feature rich offerings and come with zero-licensing fee. This makes it an attractive proposition to migrate from Oracle to an open-source distribution, to cut-down on licensing costs. Migrating an application from a commercial vendor to open source is based on typical concerns of functionality and performabilty. Though there are various tools and offerings available to migrate but currently there exists no reference points for the exact effort and impact of migration on the application. Thus we did a study of impact analysis and effort involved in migrating on OLTP application. We successfully migrated the application and did a performance comparison, which is covered in the paper. The paper also covers the tool and methodology used, along with the limitations of MySQL and presents learnings of the entire exercise.