Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Requesting automation ideas for a monthly data export (select tables) from Oracle with delimeters and importing into MySQL

Posted on 2011-02-16
1
Medium Priority
?
791 Views
Last Modified: 2013-12-19
Hello,
I am looking for any automation ideas for a monthly data export (select tables) from Oracle with delimiters and importing into MySQL.

 - I use phpAdmin to access the MySQL as well as command line for the larger imports.
- For exporting data into a text file from Oracle I use Toad.

I would like to automate this to run monthly on a few tables (not the whole database). Your suggestions would be greatly appreciated. Thank you.
0
Comment
Question by:cassie5643
1 Comment
 
LVL 8

Accepted Solution

by:
rationalboss earned 2000 total points
ID: 34907842
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-oracle.html
http://www.mysql.com/products/workbench/


Willing to pay?
http://www.convert-in.com/ora2sql.htm
You can also try using WisdomForce which would convert Oracle to flat text files quickly. You may also select just which tables to extract from Oracle. Then, it will create the files needed by MySQL.


But read this! :)
http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question