On Thu, Nov 18, 2010 at 2:54 PM, Sydney Puente wrot
> a mysqldump might do that job too, but the output from mysqldump
> --compatible
> was rejected by oracle.
>
Hmm. Interesting, you might want to file an issue about that - now that
MySQL is oracle-owned, you'd expect at least that to work, wou
rejected by oracle.
-Syd
- Original Message
From: Kevin (Gmail)
To: Johan De Meersman ; Shawn Green (MySQL)
Cc: Sydney Puente ; mysql@lists.mysql.com
Sent: Wed, 17 November, 2010 18:17:38
Subject: Re: export db to oracle
Hello,
It should be possible to connect Oracle to the MySQL
You can try using Oracle SQL Developer Tool which got the data import
function from MySql.
On 11/17/2010 4:14 AM, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have c
or ETL and data integration and it is
very manageable.
You can trap errors using cursors if the data has anomalies.
Kevin O'Neill
- Original Message -
From: "Johan De Meersman"
To: "Shawn Green (MySQL)"
Cc: "Sydney Puente" ;
Sent: Wednesday, Novemb
On Wed, Nov 17, 2010 at 2:26 PM, who.cat wrote:
> Maybe you can dump as a csv format,then create table all tables in oracle
> .After that you can write a script program format the csv to oracle which
> can be recognized.
>
MySQL's select into outfile may well be good enough to manage to output
o
On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
> On 11/16/2010 15:14, Sydney Puente wrote:
>
>> Hello,
>>
>> How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I
>> need
>> to pass the data to oracle, just so the data can be transfered
On 11/16/2010 15:14, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas? It
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas? It is on Redhat if that makes a difference.
