Re: MySQL -> Oracle Migration

Soma Interesting wrote: > > I'd like some input on what considerations there are about developing a > solution in MySQL that will ultimately be moved to Oracle. We're inclined > to avoid the ODBC functions for better performance. I've seen some debate > as to if ODBC actually significantly affects performance negatively. So my > questions essentially are: > > 1) Is migrating from the MySQL -> Oracle functions a reasonable approach vs > just using the ODBC functions. > 1.5) What about migrating from ODBC functions directly to Oracle functions. > 2) Are there already tools that will automate converting PHP code from one > to another? > 3) If we choose developing on MySQL and migrate to Oracle, are there > considerations in how the code should be written to make the migration > simpler? > Have you considered using Postgres instead of MySQL for development? While this would shurely not solve the problems you've mentioned, you can develop your data model and your application much better so they can make use of features like referential integrety or subselects that are not available with MySQL or avoid MySQL features like the LIMIT in SELECTs that can give you a hard time porting to Oracle. -Andreas -- Andreas Karajannis GMD National Research Center for Information Technology Schloss Birlinghoven, D-53754 Sankt Augustin Phone +49 2241 142948