Syinc databases mySQL to Oracle

1 vote

1 answer

118 views

mysql-5.6 data-synchronization oracle-8i

                          I'm new in "databaase administration"
the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one).

**What I've done till now** 

Searched for two days.

I installed MySQL connector/odbc on the 'oracle machine' and successfully connected to the remote MySQL database 

Also I can execute queries from the oracle machine like:

    select * from remote_table;

and it shows the expected results,
 
**The problem here is:**
Is there a way to sync these two databases (mySQL to oracle), or at least update the local one every midnight..

**About the two machines**

Both machines are running Windows OS

**local one :**
Running Windows XP
Oracle 8i 

**remote one :** 
Running Windows 8.1
MySql 5.6.17
                        

Asked by Charaf Eddine Mechalikh (111 rep)

Dec 25, 2015, 02:41 PM
Last activity: Dec 23, 2020, 10:04 PM

Syinc databases mySQL to Oracle

Related Questions