?
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
?
783 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 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

719 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