Re: Migration from ORACLE 9i to MySQL
Shawn, others, Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. It all depends on the application it's used for. MySQL 5 is a very nice release - once stable, of course - but in some regards, it has a long way to go. No doubt, many Oracle applications can be converted to MySQL, but this is because those applications don't use Oracle well enough :) IMO, duplicating something that can, could and should be done on the server in client code is a step backwards. In earlier days, the foreign key constraints like described in the MySQL documentation was a shining example of ignorance on the part of the documentation writers. Luckily, InnoDB has foreign key constraints. But there are plenty of other applications that cannot be converted to MySQL, no doubt, some run fine and dandy... We use MySQL here in the office as well, but use InterBase and Firebird for others... The right tool for the job makes the whole difference. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration from ORACLE 9i to MySQL
Shawn Green, You are right? I agree as you said Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Thank you for input, Nguyen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 2:25 PM To: Johnson, Michael Cc: mysql@lists.mysql.com; 'Nguyen, Phong' Subject: RE: Migration from ORACLE 9i to MySQL Johnson, Michael [EMAIL PROTECTED] wrote on 07/28/2005 01:56:33 PM: Why are you going backwards MySql is an 8th grade toy. -Original Message- From: Nguyen, Phong [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 9:42 AM To: mysql@lists.mysql.com Subject: Migration from ORACLE 9i to MySQL I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: Migration from ORACLE 9i to MySQL
Thank you for your input, V/R, Phong -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 3:41 AM To: Johnson, Michael ; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com; 'Nguyen, Phong' Subject: Re: Migration from ORACLE 9i to MySQL Shawn, others, Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. It all depends on the application it's used for. MySQL 5 is a very nice release - once stable, of course - but in some regards, it has a long way to go. No doubt, many Oracle applications can be converted to MySQL, but this is because those applications don't use Oracle well enough :) IMO, duplicating something that can, could and should be done on the server in client code is a step backwards. In earlier days, the foreign key constraints like described in the MySQL documentation was a shining example of ignorance on the part of the documentation writers. Luckily, InnoDB has foreign key constraints. But there are plenty of other applications that cannot be converted to MySQL, no doubt, some run fine and dandy... We use MySQL here in the office as well, but use InterBase and Firebird for others... The right tool for the job makes the whole difference. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migration from ORACLE 9i to MySQL
from a purely religous logical architecture viewpoint it is better to keep the business rules as close to the persistence layer (ex. RDBMS) as possible. in the practical physical/business world it is severly hyperlinearly expensive (both hardware as well as Oracle licenses) to support that model. put another way: Oracle is an insanely expensive application server but my wife's in sales there so as long as people keep writing those seven figure checks I'm not going to complain too much... :-) personally, I've been very impressed w/MySQL so far. we use it to run several sections of our site that run tens of millions of queries per day. MySQL replication has also been orders of magnitude more stable than AQ ever was. we have been replicating about 16GB/day across 12 nodes for months without the slightest hiccup. just don't ask me to do SQL/Server! when an RDBMS is responsible for the biggest DOS in the history of the internet that should tell you something... there, if we're going to flame let's at least pick a target we cal all agree on... :) It all depends on the application it's used for. MySQL 5 is a very nice release - once stable, of course - but in some regards, it has a long way to go. No doubt, many Oracle applications can be converted to MySQL, but this is because those applications don't use Oracle well enough :) IMO, duplicating something that can, could and should be done on the server in client code is a step backwards. In earlier days, the foreign key constraints like described in the MySQL documentation was a shining example of ignorance on the part of the documentation writers. Luckily, InnoDB has foreign key constraints. But there are plenty of other applications that cannot be converted to MySQL, no doubt, some run fine and dandy... We use MySQL here in the office as well, but use InterBase and Firebird for others... The right tool for the job makes the whole difference. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration from ORACLE 9i to MySQL
Why are you going backwards MySql is an 8th grade toy. -Original Message- From: Nguyen, Phong [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 9:42 AM To: mysql@lists.mysql.com Subject: Migration from ORACLE 9i to MySQL I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migration from ORACLE 9i to MySQL
Johnson, Michael [EMAIL PROTECTED] wrote on 07/28/2005 01:56:33 PM: Why are you going backwards MySql is an 8th grade toy. -Original Message- From: Nguyen, Phong [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 9:42 AM To: mysql@lists.mysql.com Subject: Migration from ORACLE 9i to MySQL I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Maybe the US Air Force has an unlimited budget but the rest of us do not. It seems to me that they powers that be in Nguyen's shop have made a decision (rational or not, you know how some managers are) to move away from a PREMIUM-priced package like 9i to something that can perform comparably to 9i but at a small fraction of the cost. Calling it an 8th grade toy makes you sound uninformed of what MySQL is really capable of. Sure MySQL may have a few fewer bells and whistles than Oracle but if you don't need to rely on all of the gee-whiz and just need fast, stable data storage and retrieval, MySQL is an excellent choice. Besides, most of those fancy things in the premium databases can be duplicated or nearly duplicated using very little client-side code. Of the things that cannot be run in client-side code (I am particularly thinking of stored procedures and triggers) those are coming in 5.0.x. Do you think NASA, Yahoo, and a host of other Fortune 100 companies made a mistake by using MySQL in their production enviroments? I don't. Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Migration from ORACLE 9i to MySQL
I got no experience in migrating Oracle to Mysql, but here might be what you were looking for: http://dev.mysql.com/downloads/migration-toolkit/1.0.html Scott On 7/28/05, Nguyen, Phong [EMAIL PROTECTED] wrote: I will be migrating Oracle database 9i to Mysql. Do anyone have any experience in doing this?. Please share with us! Thank you very much, V/R, Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Power to people, Linux is here.
Re: Migration from ORACLE 9i to MySQL
Johnson, Michael wrote: MySql is an 8th grade toy. So why are you here? Go haunt an Oracle mailing list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]