MySQL 4.x to Oracle Notes

October 11, 2007

Stumbled across this useful page full of examples and notes on how MySQL 4.x and Oracle differ, and how you can avoid complications if you want to migrate a database between the two…

About once a year I need to migrate a medium-sized web application using MySQL to Oracle.

Usually it’s to prepare a successful intranet application for a move to a formally supported production environment - and in Silicon Valley, that usually means Oracle.

I was apologizing to Monty at OSCON this year about my latest migration project away from MySQL.

His surprising response was, “It’s not a bad thing. I don’t mind hearing about conversions because successful migrations demonstrate that people don’t have to worry about database lock-in.”

Here’s some notes on doing migrations.