Link to home
Start Free TrialLog in
Avatar of Ti360

asked on

Load MySQL table from Oracle DAtabase - daily update

Hello Experts,

We are in the migration process of an old application.  Its using a scheduled DTS package jobs on an SQL 2000 to pull data from Oracle database and update/insert in an SQL table.  The new application is running on MySQL, my problem is to replicate what that DTS package was doing as the information pull from oracle database still need to be updated on MYSQL tables.

Any help appreciated.
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
there is MySql workbench which can be used to migrate data from different DBMS to MySql DB. here is the step by step process there is a option for schedule it as well.
Avatar of Ti360


Sorry for the delay but MariaDB was the final solution.. Thanks!