Re: [PHP-DB] MySQL -> Oracle Migration From: Andreas Karajannis (Andreas.Karajannis <email protected>)
Date: 11/17/00

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>