Anticlue

MySQL Migration Toolkit: an overview

One of the tools to keep in your toolkit is the MySQL Migration Toolkit. The new release supports migrating Oracle, SQL Server, and Access databases to MySQL. For Access migrations, just remember to show the system objects and allow the admin security group read design access to MsysObjects and MsysQueries.

Also if you are looking to go between machine and machine, check out agent-based migrations. In this scenario the toolkit resides on a separate machine, maybe your work machine. The agent is set up to migrate the source machine to the target machine without going through the MySQL Migration Toolkit setup on your work machine.