Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: