I need to migrate about a dozen tables from ORACLE 10g to MySQL 5. I
have manually migrated the schema to MySQL. I am able to write SQL*PLUS
queries to extract ORACLE data into insert statements (including date
conversions to MySQL format etc) that I can run against the MySQL
database. The CLOB
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table
-Nachricht
Datum: Fri, 31 Aug 2007 09:30:13 -0400
Von: Baron Schwartz [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Betreff: Re: JOIN migration from Oracle to MySQL
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script
[EMAIL PROTECTED] wrote:
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
Unless you are
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 funny).
Ah right :-)
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
other
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
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
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
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
: 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
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL. In
this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All of these things point to
decreased TCO when using MySQL
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
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
@lists.mysql.com
Subject: Migration from Oracle to MySQL
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL.
In this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All
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
-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
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
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.
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]
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
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
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
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]
Subject: Re: Migration from Oracle
Dear Stefan,
Thank you for your help.
I used MyODBC 3.51, and successfully migrated to MySQL.
Regards
Satish
Stefan Hinz, iConnect (Berlin) wrote:
Dear Satish,
I want to migrate from Oracle to MySQL.
So I need to import the tables and data from
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
Subject: Re: Migration from Oracle
Dear Stefan,
Thank you for your
Hi All,
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.
Regards
Satish
-
Before
7970948-3
- Original Message -
From: Satish Vohra [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 5:12 PM
Subject: Migration from Oracle
Hi All,
I want to migrate from Oracle to MySQL.
So I need to import the tables and data from Oracle.
Can anyone suggest any
29 matches
Mail list logo