export db to oracle

Hello, How can I export a mysql 5.0.45 db to Oracle? mysql is going to=
stau but I need =0Ato pass the data to oracle, just so the data can be tra=
nsfered.=0AI have carried out a mysql dump. This seems fine.create table et=
c. about 20 MB =0Ain total. Any ideas? It is on Redhat if that makes a=
difference. TIA -Syd =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: export db to oracle

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 is on Redhat if that makes a difference.

I suggest you also look at the syntax for SELECT INTO OUTFILE, too.
Dumps are usually scripts of SQL statements that Oracle may not read
appropriately.

--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: export db to oracle

--00221532cd10bf8f5604953bdf18
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL) <
shawn.l.green@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.
>> 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.
>>
>
> I suggest you also look at the syntax for SELECT INTO OUTFILE, too. Dumps
> are usually scripts of SQL statements that Oracle may not read
> appropriately.
>

I'm not quite sure which formats Oracle reads in, although CSV is probably a
good guess.

if you disable mysqldump's extended insert syntax, however, I think the
actual insert statements should be perfectly fine for most any database. You
may need to tweak create statements for datatypes and syntax, though; it may
be easier to just recreate the emtpy tables by hand.

I think I also have vague memories of an option to use ANSI-SQL standard
syntax, although that might just as well have been some third-party tool.

And, speaking of third-party tools: tOra can (if well-compiled) be used to
manage both MySQL and Oracle; maybe that nice tool can help you.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00221532cd10bf8f5604953bdf18--

Re: export db to oracle

--00221534d527711d27049540a0b8
Content-Type: text/plain; charset=ISO-8859-1

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
oracle-formatted inserts; and as I said standard (non-extended) insert
syntax is probably good enough for oracle anyway.

If you're going to be programming anyway, why not just write something that
connects to both DBs and inserts into Oracle using prepared statements for
speed ?



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00221534d527711d27049540a0b8--

Re: export db to oracle

Hello,

It should be possible to connect Oracle to the MySQL (or other) database
using a DBlink (using a MySQL ODBC driver)
the tables could then be copied using PLSQL.
Maybe you could link directly to Oracle and copy the code using MySQL
procedures or scripts (I have more experienc of Oracle which works quite
well as I described)

This way, you can avoid use of external files and CSV etc. It is very likely
quicker since you can use bulk loads or 'select into' routines once you have
the right table structures and field type in place.
This is a technique that I have used for 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, November 17, 2010 8:58 AM
Subject: Re: export db to oracle


> On Wed, Nov 17, 2010 at 1:43 AM, Shawn Green (MySQL) <
> shawn.l.green@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.
>>> 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.
>>>
>>
>> I suggest you also look at the syntax for SELECT INTO OUTFILE, too. Dumps
>> are usually scripts of SQL statements that Oracle may not read
>> appropriately.
>>
>
> I'm not quite sure which formats Oracle reads in, although CSV is probably
> a
> good guess.
>
> if you disable mysqldump's extended insert syntax, however, I think the
> actual insert statements should be perfectly fine for most any database.
> You
> may need to tweak create statements for datatypes and syntax, though; it
> may
> be easier to just recreate the emtpy tables by hand.
>
> I think I also have vague memories of an option to use ANSI-SQL standard
> syntax, although that might just as well have been some third-party tool.
>
> And, speaking of third-party tools: tOra can (if well-compiled) be used to
> manage both MySQL and Oracle; maybe that nice tool can help you.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: export db to oracle

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 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.
>
> TIA
>
> -Syd
>
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: export db to oracle

Hi,=0AActually all the helpful tips that I have gotten have caused me to re=
view the =0Arequirements!=0AI now realise that that csv or xml files for th=
e storage of an extract would be =0Ahelpful, for testing and validation.=0A=
a mysqldump might do that job too, but the output from mysqldump --compatib=
le =0Awas rejected by oracle. -Syd ----- Original Message=
----=0AFrom: Kevin (Gmail) =0ATo: Johan De Meersman =
; Shawn Green (MySQL) =0A=0AC=
c: Sydney Puente ; mysql@lists.mysql.com=0ASent: We=
d, 17 November, 2010 18:17:38=0ASubject: Re: export db to oracle Hello=
, It should be possible to connect Oracle to the MySQL (or other) data=
base using a =0ADBlink (using a MySQL ODBC driver)=0Athe tables could then =
be copied using PLSQL.=0AMaybe you could link directly to Oracle and copy t=
he code using MySQL procedures =0Aor scripts (I have more experienc of Orac=
le which works quite well as I =0Adescribed) This way, you can avoid u=
se of external files and CSV etc. It is very likely =0Aquicker since you ca=
n use bulk loads or 'select into' routines once you have the =0Aright table=
structures and field type in place.=0AThis is a technique that I have used=
for ETL and data integration and it is very =0Amanageable.=0AYou can trap =
errors using cursors if the data has anomalies. Kevin O'Neill ---=
-- Original Message ----- From: "Johan De Meersman" =0A=
To: "Shawn Green (MySQL)" =0ACc: "Sydney Puente" =
; =0ASent: Wednesday, Novemb=
er 17, 2010 8:58 AM=0ASubject: Re: export db to oracle =0A> On Wed, No=
v 17, 2010 at 1:43 AM, Shawn Green (MySQL) <=0A> shawn.l.green@oracle.com> =
wrote:=0A> =0A>> On 11/16/2010 15:14, Sydney Puente wrote:=0A>> =0A>>> Hell=
o,=0A>>> =0A>>> How can I export a mysql 5.0.45 db to Oracle? mysql is goin=
g to stau but I=0A>>> need=0A>>> to pass the data to oracle, just so the da=
ta can be transfered.=0A>>> I have carried out a mysql dump. This seems fin=
e.create table etc. about=0A>>> 20 MB=0A>>> in total.=0A>>> =0A>>> Any idea=
s? It is on Redhat if that makes a difference.=0A>>> =0A>> =0A>> I suggest =
you also look at the syntax for SELECT INTO OUTFILE, too. Dumps=0A>> are us=
ually scripts of SQL statements that Oracle may not read=0A>> appropriately=
..=0A>> =0A> =0A> I'm not quite sure which formats Oracle reads in, although=
CSV is probably a=0A> good guess.=0A> =0A> if you disable mysqldump's exte=
nded insert syntax, however, I think the=0A> actual insert statements shoul=
d be perfectly fine for most any database. You=0A> may need to tweak create=
statements for datatypes and syntax, though; it may=0A> be easier to just =
recreate the emtpy tables by hand.=0A> =0A> I think I also have vague memor=
ies of an option to use ANSI-SQL standard=0A> syntax, although that might j=
ust as well have been some third-party tool.=0A> =0A> And, speaking of thir=
d-party tools: tOra can (if well-compiled) be used to=0A> manage both MySQL=
and Oracle; maybe that nice tool can help you.=0A> =0A> -- Bier met grenad=
yn=0A> Is als mosterd by den wyn=0A> Sy die't drinkt, is eene kwezel=0A> Hy=
die't drinkt, is ras een ezel=0A> =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: export db to oracle

--001636c5a7a5a4f9230495611705
Content-Type: text/plain; charset=ISO-8859-1

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, wouldn't you :-p

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001636c5a7a5a4f9230495611705--