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 fie
[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 r
-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
[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 aren'
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:
selec
> >> 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
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
> > 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
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
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
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
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
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 of
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
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 i
16 matches
Mail list logo
