Re: Migration from Oracle to MySQL

2007-07-31 Thread Martijn Tonies
> >> LOL - an entertaining read! > >> > > > > Entertaining? I feel to see the humor in his post. > > > > > I thought it was concise and well written, with an undertone of "I know > I'm swearing in church but...". So yes, I found it entertaining (I agree > that it was not necessarily humorous or fun

Re: Migration from Oracle to MySQL

2007-07-30 Thread Mark Kirkwood
Martijn Tonies wrote: LOL - an entertaining read! Entertaining? I feel to see the humor in his post. I thought it was concise and well written, with an undertone of "I know I'm swearing in church but...". So yes, I found it entertaining (I agree that it was not necessarily humorous

Re: Migration from Oracle to MySQL

2007-07-30 Thread Martijn Tonies
> > Storage engines are unique to MySQL? yes. Is that good? YMMV. Most > > of the purported benefits can be achieved with Oracle's features > > without the compromises of balkanised storage engines. You're right, > > they're not offered by Oracle, or anyone else ... there's a reason no > > oth

Re: Migration from Oracle to MySQL

2007-07-29 Thread Mark Kirkwood
Grant Allen wrote: Storage engines are unique to MySQL? yes. Is that good? YMMV. Most of the purported benefits can be achieved with Oracle's features without the compromises of balkanised storage engines. You're right, they're not offered by Oracle, or anyone else ... there's a reason no

Re: Migration from Oracle to MySQL

2007-07-27 Thread Luca Ferrari
On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard, wrote: > Check out > http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html > Please note that PostgreSQL provides a gateway to other databases thanks to the DBI-Link extension, as well as it support more than o

Re: Migration from Oracle to MySQL

2007-07-26 Thread Grant Allen
Tangirala, Srikalyan wrote: Hi All: Could you provide some more information about Oracle limitations, MySQL limitations, Oracle vs. MySQL etc? Sure, let's play devil's advocate for a minute. Some things unique to MySQL that Oracle does not offer include: - Storage engines, choices like In

RE: Migration from Oracle to MySQL

2007-07-26 Thread sliebman
: RE: Migration from Oracle to MySQL Check out http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html Raj Mehrotra hccs - Experts in Healthcare Learning [EMAIL PROTECTED] -Original Message- From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007

RE: Migration from Oracle to MySQL

2007-07-26 Thread Tangirala, Srikalyan
Thanks for your input Raj. Regards, Sri -Original Message- From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 11:32 AM To: Tangirala, Srikalyan; cluster Cc: mysql@lists.mysql.com Subject: RE: Migration from Oracle to MySQL Check out http://www-css.fnal.gov

RE: Migration from Oracle to MySQL

2007-07-26 Thread Rajesh Mehrotra
Check out http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html Raj Mehrotra hccs - Experts in Healthcare Learning [EMAIL PROTECTED] -Original Message- From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 11:11 AM To: cluster Cc: mysql@list

Re: Migration from Oracle to MySQL

2007-07-26 Thread Martijn Tonies
Hi, >Could you provide some more information about Oracle limitations, MySQL >limitations, Oracle vs. MySQL etc? I thought it was your study? MySQL doesn't have (compared to Oracle): - check constraints - a procedural language as mature as Oracle PL/SQL - triggers on a per statement basis as Ora

Re: Migration from ORACLE 9i to MySQL

2005-07-29 Thread Sid Lane
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.

RE: Migration from ORACLE 9i to MySQL

2005-07-29 Thread Nguyen, Phong
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 Sha

RE: Migration from ORACLE 9i to MySQL

2005-07-29 Thread Nguyen, Phong
k 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 " <[E

Re: Migration from ORACLE 9i to MySQL

2005-07-29 Thread Martijn Tonies
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 ca

Re: Migration from ORACLE 9i to MySQL

2005-07-28 Thread Warren Young
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]

Re: Migration from ORACLE 9i to MySQL

2005-07-28 Thread Scott Hamm
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 > expe

RE: Migration from ORACLE 9i to MySQL

2005-07-28 Thread SGreen
"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: M

RE: Migration from ORACLE 9i to MySQL

2005-07-28 Thread Johnson, Michael
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 a

Re: Migration from Oracle

2002-12-14 Thread Satish Vohra
<[EMAIL PROTECTED]> > To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> > Sent: Thursday, December 12, 2002 12:27 PM > Subject: Re: Migration from Oracle > > Dear Stefan, > > Thank you for your help. > I used MyODBC 3.51, and successfully migrated to My

Re: Migration from Oracle

2002-12-12 Thread Stefan Hinz
> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Satish Vohra" <[EMAIL PROTECTED]> To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 12:27 PM Subjec

Re: Migration from Oracle

2002-12-11 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Satish, > I want to migrate from Oracle to MySQL. > So I need to import the tables and data from Oracle. > Can anyone suggest any tool which can do this. > Any pointer regarding this will be appreciated. (1) I am not familiar with Oracle, but I assume (oh, that word again) that it has a dump