AW: [PHP-DB] Any issues when moving from mySQL to Oracle 8i?

Olivier, thanks for these tips. If i find some more pitfalls i will post them. Have fun, Joe > -----Ursprungliche Nachricht----- > Von: Olivier Bourgeois [mailto:olivier@digifactory.fr] > Gesendet: Donnerstag, 9. November 2000 18:49 > An: JMaier@maiersoft.de > Cc: php-db@lists.php.net > Betreff: Re: [PHP-DB] Any issues when moving from mySQL to Oracle 8i? > > > > Hi all, > > > > i'm planning to move a mySQL-DB to Oracle 8i. > > > > Ideally i would dump the mySQL-DB and import the dump with SQL*Plus. > > Is this direction of migration possible without greater problems? > > > > Or are there any issues i should especially take care of in advance(data > > types, SQL syntax). > > Any experiences are greatly appreciated. > > > > Have fun, > > Joe > > > > Hi Joe, > for this job you should double check the datatypes : for exemple > mysqldump dumps integer fields with datatype INT (length_of_int) . This is > not correct for Oracle. > Look also at TEXT and DATETIME wich have to be converted to CHAR, > VARCHAR, CLOB .. (depending on your needs) and TIME > If you're using AUTO_INCREMENT fields you'll need to deal > with sequences > (I've posted in this ML recently about this). > I think that's all for Data Definition Language. The SQL should be ok > > If you experience other problems, feel free to send feedback > > Bye. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >