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.
DatabasesOracle DatabaseMySQL Server
Last Comment
Ti360
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Sorry for the delay but MariaDB was the final solution.. Thanks!
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html