Migrating MySQL to Oracle Guide

March 1, 2011

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.

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.

Installation & Administration Considerations
Query and Optimizer Differences
Security Strengths and Weaknesses
Replication & High Availability
Table Types & Storage Engines
Applications, Connection Pooling, Stored Procedures and More
Backups & Disaster Recovery
Community – MySQL & Oracle Differences
TCO, Licensing, and Cloud Considerations
Advanced Oracle Features – Missing in MySQL

Check back soon as we update each of these sections.

Anonymous
Thank you for your time and effort but i wouldn’t call it “Guide”
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:
http://us1.campaign-archive1.com/?u=4d383486fdb4338aa674c9657&id=a9e2a16246&e=9d03f18dca
gangs
hey, are you planning to ‘update each of these sections’?
http://www.bing.com/ Debra
That’s an intelligent answer to a dfifuiclt question xxx
Pingback: Oracle to MySQL Migration Considerations « «Heavyweight Internet GroupHeavyweight Internet Group
Pingback: Migrating MySQL to Oracle « «Heavyweight Internet GroupHeavyweight Internet Group

Sean Hull's Scalable Startups

Blog