FWIW, I ported a 5GB MySQL database to Oracle this morning. I've also
ported many Oracle schemae to MySQL. Datatype conversion isn't that
big a deal once things are set up correctly. I have had some
nightmarish ports though. :>)
On Apr 4, 2005 2:55 PM, stephen booth <stephenbooth.uk@(protected):
> Nearly forgot another one. MySQL doesn't even try to be ANSI
> compliant in data types. Porting apps to or from it can be
> nightmarish, especially porting from where the original developer was
> kazy and just set all non-key text fields to MEMO (similar to a LONG
> in Oracle).
> It's better to ask a silly question than to make a silly assumption.