Q

Easy way to move Oracle data nightly to MySQL

Is there a quick and easy way to move Oracle 8i or 9i data nightly to a similar MySQL schema on a separate server? Most tables are less than 10,000 rows, and the servers are robust, but a few tables have more than one million rows, and a net-change process would be preferred.

Well for many situations the ideal solution is to create your own migration script/application and run it nightly. That being said, most of the GUI tools support moving data, you may wish to look at applications like SQLyog and Navicat for their offerings, as both can run scheduled data transfers.

For More Information


This was first published in May 2004

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close