Migrating MySQL to Oracle Guide

Also find Sean Hull’s ramblings on twitter @hullsean.

Migrating from MySQL to Oracle can be as complex as picking up your life and moving from the country to the city.  Things in the MySQL world are often just done differently than they are in the Oracle world.  Our guide will give you a birds eye view of the differences to help you determine what is the right path for you.

** See also: Oracle to MySQL Migration Considerations **

MySQL comes from a more open-source or DIY background.  One of Unix and Linux administrators and even developers carrying the responsibility of a DBA.

  1. Installation & Administration Considerations
  2. Query and Optimizer Differences
  3. Security Strengths and Weaknesses
  4. Replication & High Availability
  5. Table Types & Storage Engines
  6. Applications, Connection Pooling, Stored Procedures and More
  7. Backups & Disaster Recovery
  8. Community – MySQL & Oracle Differences
  9. TCO, Licensing, and Cloud Considerations
  10. Advanced Oracle Features – Missing in MySQL

Check back soon as we update each of these sections.

  • Pingback: Migrating MySQL to Oracle « «Heavyweight Internet GroupHeavyweight Internet Group

  • Pingback: Oracle to MySQL Migration Considerations « «Heavyweight Internet GroupHeavyweight Internet Group

  • http://www.bing.com/ Debra

    That’s an intelligent answer to a dfifuiclt question xxx

  • gangs

    hey, are you planning to ‘update each of these sections’?

  • hullsean

    Hi @373cdfa34ccec5a74716aa4624764011:disqus I’ve worked on some of this material, but it’s all a matter of finishing and editing. Dare I publish something that isn’t polished and the internet hordes will descend & attack. I do know this is a very popular topic, and one which doesn’t have a lot of coverage in books or blogs. Are you getting the newsletter btw? Sometimes I have different material in there. Take a look:

  • Anonymous

    Thank you for your time and effort but i wouldn’t call it “Guide”

  • Martin

    ESF Database Migration Toolkit can do this work easier. http://www.easyfrom.net/

    • http://www.iheavy.com/blog/ Sean Hull

      Thx for the comment Martin. Folks at ESF have posted on this blog before.

      Tools are great, but rarely push button despite the best engineering & marketing besides. Truth is when moving database platforms there are a ton of considerations to make. Datatypes, table types, stored code & functionality are just the beginning. Typically the database engines optimization styles, strengths and weaknesses are very different.

      All of the above means a good understanding of source and target platforms is crucial.