I'm on vacation but this one caught my eye while watching the miles go by. :) We are in the process of replacing *part* of our OLTP system with MySQL and just leaving the reporting repository in Oracle. This new environment will syncronize between MySQL and Oracle on different intervals all through sql scripts and odbc. We are in testing right now so I can't give you a lot of performance data, but its been interesting simplifying some of the Oracle features to work with MySQL and enjoying the simplicity of how MySQL just works. :) ~Kellyn Sent via BlackBerry from T-Mobile -----Original Message----- From: Betsy Ward <wardbe@xxxxxxxxxxx> Sender: oracle-l-bounce@xxxxxxxxxxxxx Date: Wed, 14 Jul 2010 15:31:04 To: <oracle-l@xxxxxxxxxxxxx> Reply-To: wardbe@xxxxxxxxxxx Subject: oracle and mysql I saw someone just posted a question about Oracle versus MySQL, and since I'm researching this, thought I would ask out here... Has anyone on this list gotten an oracle database to talk to a mysql database before? Similar to putting a dblink in oracle from one instance to another, can you do that with oracle > mysql? Would you be willing to share how you did it? I have been digging around and found the unixODBC package, which I installed but when trying to install the mysql-connector driver, I am getting errors. Is there any way to get this to work outside of using the unixODBC package? TIA, Betsy -- //www.freelists.org/webpage/oracle-l