There are several major differences that you will need to consider. 1. So far as I know MySQL does not allow you to assign tables and indexes to table spaces, hence load spreading is much more difficult. You cannot split tables and indexes so that they reside on differentt disks.
2. There are no stored procedures and triggers available in MySQL. 3. You will need to use the Innodb or equivalent extensions to get transaction processing. 4. The table and index creation syntax is different with MySQL. (Personally I found MySQL somewhat more logical). If you want to discuss the issues in more detail please e-mail me directly. Regards Peter Goggin ----- Original Message ----- From: "RP C987342" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 4:29 PM Subject: Oracle to Mysql > hello > > I want to move my database from Oracle to MySql, I am new to MySql. > > Is there any documentation listing the important issues involved > in the migration? > > thanks, > > > > _________________________________________________________________ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
