Re: 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.