2

I have access from 5 views of an Oracle DB located outside of my organization. I need to sync my db that is a mySQL DB with the oracle DB (Oracle views will be the master, my db will be the slave). I was reading about replication on MySQL DB but nothing about replication from a Oracle DB. There's anyway to I keep the tables equals? PS: I don't have access to the original tables, so I can't create a trigger there :(

  • So the entire process is driven by the mySQL side? Pulling data from oracle to mysql? What kind of time lag is allowable? Without getting into specific solutions, how will the mysql side identify oracle data that it has already pulled? How will it identify a row that has been deleted since the previous pull? How will it identify a row that has been modified since the previous pull? – EdStevens Sep 21 '16 at 22:13
  • Several years ago Oracle bought Golden Gate. It had the code to replicate from Oracle to MySQL. Perhaps it is still available from Oracle (under some other name). – Rick James Sep 27 '16 at 5:37
2

Oracle GoldenGate might not be useful for you if Oracle source database is outside of your organization with no possibility for you to set up extract process.

The best for you is to have a look at this old post "Migrate from Oracle to MySQL" that despite its title points out good ways to do what you're looking for.

I found especially useful the below points from David Mann answer to the above mentioned topic:

  1. There are 3rd party utilities available. I have used a few of these but best for you to check them out yourself for your intended purpose. A few 3rd party products are listed here: OraFaq . Unfortunately a lot of them run on Windows which would slow down the data unload process unless your DB server was on windows and you could run the load utility directly on the server.

  2. If you don't have any complex datatypes like LOBs then you can roll your own with SQLPLUS. If you did a table at a time then you can easily parallelize it. Topic has been visited on this site probably more than once, here is an example: Linky

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.