Re: [PLUG] Oracle to MySQL?

[jason@nocks.com]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Hi all,
>
> I've got an interesting project I'm working on here. We've an Oracle
> database that holds our customer information. What I've been asked to
> investigate/do is see about being able to export some of the data in the
> oracle db and put it into a MySQL db. The MySQL db would be read only
> and used for querying only.
>
> I've thought about using an Oracle .dmp file, but it's rather large
> since it's a complete dump (about 40 gb or so). I'm not versed in oracle
> much, so I'm trying to find away to automate a method to have the oracle
> info imported into the MySQL system.
>
> Has anyone thought/done this before?

Yes, see:

http://forums.mysql.com/read.php?61,4260,4260#msg-4260

> Thanks!
> --
> Chris Mann
> Systems Administrator
> Stonebridge Bank
> cmann (at) stonebridgebank.com
> www.stonebridgebank.com
> Direct Connect: 168*265751*24
> Traditional Voice: 610.235.1515

Also, if the responses from the msyql forum members doesn't help, I'd be
happy to discuss it here as well.

Cheers,
Jason Nocks


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBuHoT3CryLfCgqRkRAmoqAJ0RZ6KvtwKjiideAhk+j5LzSINzigCfZzlT
VjOYMmL5mzhSOLDrjE6sppo=
=RgxT
-----END PGP SIGNATURE-----
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug