Re: oracle and mysql

  • From: "Kellyn" <kjped1313@xxxxxxxxx>
  • To: wardbe@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 14 Jul 2010 22:28:31 +0000

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


Other related posts: