Pages

Friday, September 28, 2007

MySQL Migration Toolkit

I've been evaluating the latest version of the MySQL Migration Toolkit to work on migrations from SQLServer 2005 to MySQL 5.1

Here are some of the things I found so far:

  1. Ease of use:
    • Very simple and fast to get up and running - I was able to get multiple databases migrated from SQLServer to MySQL without any special setup or configuration changes. Gui is straight forward and intuitive.
    • Took a little work to figure out how to 'customize' the migration though, but nothing crazy.
  2. Speed:
    • Seems relatively fast. I was able to transfer about 6 million rows in about 15 minutes.
    • Would probably be more efficient if I wasn't using an intermediary stopping point (my laptop)
    • Would benefit if I used bulk loading options, but I wasn't able to determine that right out of the box quickly.
  3. Issues:
    • Needs a 'Migrate Data Only' option for just moving data
    • Better options to handle case sensitivity issues (had to modify each table/object manually for that)
    • The handling for stored connections was not that great, and I had to keep re-creating the stored connections.
    • Should have an option to just do a bulk load from a datafile if necessary
All in all, a great shortcut to porting databases over to MySQL and moving data from one data center/location to another (Prod -> Test -> Dev, etc).

Very Slick....

No comments: