| replication between MySQL and Oracle [message #125986] |
Thu, 30 June 2005 06:32  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
