Home » Open Source » MySQL » replication between MySQL and Oracle
replication between MySQL and Oracle [message #125986] Thu, 30 June 2005 06:32 Go to next message
bluebeta
Messages: 14
Registered: June 2005
Junior Member
Hi,

We have 1 application that use the oracle 9i database. now we want to take out the registration module and translate it into web module that can be accessed through the internet.the web module may need to use the MySQL as a database.

So, our concern now is the security. We suggest to use the same database for the web module. But the client scared that if the web module directly connect to the oracle databse server, then the oracle server may be accessed by unauthorised internet user through the web module. Is it possible to happen? Please give me some advice on this matter?

Then they suggest to use the MySQL and then push the data to oracle databse using REPLICATION. So, is it possible to do replication between MySQL and Oracle database? Is it the replication module is an independent module and need to purchase or come with the database?

Can give me some suggestions or advice regarding this matter. Or provide me some others alternative way. I really need some help.

Thanks in advance for any reply.

Best Regard,
Andrene
Re: replication between MySQL and Oracle [message #133188 is a reply to message #125986] Thu, 18 August 2005 00:31 Go to previous messageGo to next message
mkirc
Messages: 3
Registered: August 2005
Location: Vienna/Austria
Junior Member
Hi,
I had a similar problem and solved it by using a third-party replication product.
Open_Replicator (www.idsopen.com) replicates Informix or Oracle DBMS to MySQL.
AfaIk Oracle Replication is only capable of replicating between Oracle DBMSs.
Cheers,
Michael

Re: replication between MySQL and Oracle [message #133191 is a reply to message #133188] Thu, 18 August 2005 00:46 Go to previous message
mkirc
Messages: 3
Registered: August 2005
Location: Vienna/Austria
Junior Member
Hi again,
sorry, the product name is:
IDS_Replicator, can be found on www.idsopen.com

Cheers !
Previous Topic: advantages of oracle on mysql
Next Topic: Oracle9i replication to MYSQL 5.0
Goto Forum:
  


Current Time: Fri Mar 29 08:37:39 CDT 2024