Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Here's the situation: I need to automatically merge data from an Oracle and a MySql server into a single, new MySql server. The merging will happen daily, and the resulting server will be hosted on a separate machine that will be used for all further queries, reducing the load on the original servers.

I'll use mysqldump for the MySql portion, but I'm hesitant to decide on a method of importing the Oracle data. Many companies sell tools for this purpose, but I need to do this on a budget of $0.

The posts I found on Google contained mostly commercial solutions, with very little discussion about non-commercial ones. Since this is a task that will run daily, I want to be sure I'm using the best method, but I won't be able to make the correct choice without enough information.

I'm not looking specifically for a pre-made product, only a solution to my problem (ie. if the solution involves scripting, I'm happy to write a few lines of Python given some pointers). Any method of importing Oracle data into MySql is worth consideration. What I'm looking for is a general direction of where I should be heading, be it a pre-made product or a roll-your-own solution.

My Oracle data consists of mostly integers, dates, and text, which includes a lot of Chinese characters. There are also URLs scattered throughout and unique IDs (which I will need to convert to autonumbers). This may/may not change in the future, so a flexible solution is preferred.

Google's search results turn up outdated by at least three years - since this is a task that will be running daily, I want to make sure I'm using the best/most recent method. What's an up-to-date, efficient method of importing data from Oracle to MySql?

share|improve this question
    
It's impossible on a budget of $0 unless you don't get paid either. –  a_horse_with_no_name Jul 9 '13 at 10:49
    
@a_horse_with_no_name Ironically, I'm not getting paid - I'm only working here as an intern. –  sorbet Jul 9 '13 at 14:33
    
What specifically is wrong with the "3 year old" thing you found? That's not that old, and unless it doesn't cover specific things you need, it should work. If it doesn't cover some of your needs, you should probably tell us about those. –  Mat Jul 9 '13 at 17:27
    
@Mat This is actually my first time with database management of any sort, and a lot can happen in three years. If there's been a format change that would render the previous solutions inoperable or otherwise undesirable, I wouldn't know about it. Also, the posts I found contained mostly commercial solutions, with very little discussion about non-commercial ones. Since this is a task that will run daily, I want to be sure I'm using the best method, but I won't be able to make the correct choice without enough information. –  sorbet Jul 10 '13 at 3:27
    
@Mat Without previous experience, it's safer for me to ask first before attempting anything on my own. Besides, there's nothing wrong with wanting to use a more recent solution if one exists. –  sorbet Jul 10 '13 at 3:28
show 3 more comments

migrated from stackoverflow.com Jul 9 '13 at 10:46

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.