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
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.
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
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
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
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]
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
o: 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
>
> --
&g
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
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]
<[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
>
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
y)
Telefon: +49 30 7970948-0 Fax: +49 30 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 Orac
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 posting,
29 matches
Mail list logo
