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
- Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
- The Best MySQL Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.