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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay but MariaDB was the final solution.. Thanks!
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html