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
770 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
rationalboss earned 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

623 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