Re: [PHP-DB] Any issues when moving from mySQL to Oracle 8i? From: Olivier Bourgeois (olivier <email protected>)
Date: 11/09/00

> 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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>