MySQL Visual Database Migration Tool

Nothing like good timing. I am working on a project with a company right now who has elected to migrate more than 30 Microsoft Access databases of various size and complexity used internally and on the web to MySQL 4.

To my own and all of our good fortunes — MySQL AB today announced the free availability of the MySQL Migration Suite. This GUI toolset will allow for comprehensive migration from Oracle and Access initially (with Microsoft SQL Server, IBM DB 2 and others to follow) and is released under the GPL 2 license.

Better yet it is written in Java, meaning one can perform cross-platform database migrations (Unix to Windows, Solaris to Linux and so on). The Suite utilizes time-tested methodologies and a Wizard guide to cover all the basics of migration as well as stored procedures and triggers.

With its handy reporting capabilities, audits and due diligence can be performed on migrations as they are expedited to insure no missing links are passed over.

I am going to do some test migrations in my development environment as taking anything brand new into production can be interesting to say the least. However – this looks to save some serious time and potential headaches.

Breaking with my habit of not mentioning the products I use – normally I have used Navicat during the migration process as it also spans multiple operating systems (specifically Linux, Mac and Windows). It has done its job superbly – however – the MySQL Migration Suite being GPL open source – I absolutely have to give it a run through the paces to see how it performs.

With Navicat 7 pending release and adding several features I felt were missing from version 6 – it may keep me from adopting the MySQL Suite. However, it will not keep me from giving it a good bench test on this current Access project!

For those who also work with MySQL in a commercial capacity (paying for MySQL services or licensing) — the company is also offering quite an appealing $1500 discount on their own consulting services for getting a 5-day kickstart with MySQL 5 deployments.

Free book: Jump Start HTML5 Basics

Grab a free copy of one our latest ebooks! Packed with hints and tips on HTML5's most powerful new features.

  • http://www.tysonkirksey.com skanxalot

    Exactly what I’ve been waiting for! Thanks Blane!

  • http://www.realityedge.com.au mrsmiley

    That is a seriously cool tool. Pity it doesn’t support SQL Server yet, so for the moment I’m going to have to rely on DTS which doesn’t always do the job correctly.

  • Ned Collyer

    KuraFire: my first 2 sentences talk about the need for validation wether it be XHTML or HTML :).

    I did also mention that XHTML will improve seperation between layout and content, and also that you are able to bloat it.

    All the points I make are to be taken together. Sayin HTML can do point 1/ slightly better (WOOO i save a couple of characters) is irrelevant.

    Also, its all about seperation. Code practices are always going to drive quality, XHTML .. if you start learning it.. is pretty much written for the data. (eg, seperation)

    Its better for me. There are the facts (for me at least) in my previous post.

  • http://www.dynamicfunctions.com Kadence

    A tool for most things you need already exists out there…the problem is finding it.

  • Anonymous

    i’ve visited this site, it’s so good.

  • arnek

    Well, I must say, we had a huge problem when we tried to migrate from Oracle to MySQL, shame this came to late…

    Oh yeah, and last but not least … MySQL Rules !!!

  • http://www.pbfan.com/blogs/ Automatik

    Great tool, I’m glad I read this blog!

  • tim

    good article. Your 30 Access db migration project – does it contain lots of VBA and if so how much of an issue is that in dealing with migration?

  • http://www.practicalapplications.net bwarrene

    [QUOTE=tim]good article. Your 30 Access db migration project – does it contain lots of VBA and if so how much of an issue is that in dealing with migration?[/QUOTE]

    In this case- the application logic was being handled by Cold Fusion. Part of this migration aside from moving from Access to MySQL is moving the Cold Fusion codebase to PHP.

    They are wanting to leverage some specific functions in a more open language like PHP so they can host on Linux, utilize some image handling and pdf creation tools and move toward XML.

    Though those things can be done with CF on Windows – they felt getting their architecture onto Linux now was the way to go based on their future planning.

  • mike

    There is another excellent, visual data migration tool available at http://www.akcess.in.

    It is a generic any to any type database migration tool, currently supports Oracle, MS SQL Server, My SQL, PostgreSql. Any of these databases can be source as well as target database.

  • Hare Rama

    I have tried few JDBC type 4 drivers and Visual Migration Tools including one from MySQL. All of them choke when the table size goes beyond size of available memory. Problems with heap. I tried Xmx and Xms options but looks like JDBC4 drivers are trying to create structure of the entire table in memory. Any suggestions ?