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
744 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

749 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