Comparison between Oracle and MySQL

[unnikris]

Hi folks,

I am a newbie to this forum and to MySQl. I wish to migrate an existing database from Oracle 8i to MySQL. My queries are:
1. Is there anyone who could help compare Oracle and MySQL.
or provide a link to any website which offers the same.
2. Is there any migration tool available for migrating from Oracle 8i to MySQL.

Any help would be appreciated,
Thanx in advance,
unnikris

 

[tonedef]

Some things you might miss from Oracle:
foreign keys
stored procedures
triggers
transactional processing (commit/rollback)

Those are the biggies. There are probably more. Don't get me wrong, there are some things in MySQL that I like over Oracle, most notably a boolean type, oh and cost! Also foreign keys and trans. processing are partially supported in the latest version of MySQL and all of the above are planned to be supported (or supported better) in future versions.

MySQL.com has some comparisons in there crash-me section. Also go to google and do a search on MySQL vs. Oracle and you will get a ton of threads like this one that may help you.

HTH,

tone