This Content Component encountered an error

Oracle on Linux tips, tutorials and expert advice

Migrating Oracle data on Linux <<previous|next>> :Migrating from Oracle to Linux -- tips and TCO considerations

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

17 May 2004