Chris Mann on 9 Dec 2004 15:47:02 -0000


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[PLUG] Oracle to MySQL?


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?

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

___________________________________________________________________________
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