MySQL Migration Toolkit 1.0.12 rc has been released. All users are recommended to update to this new release.
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
The Toolkit has support for:
1) "Generic migration" from Any Database that has a JDBC Driver.
2) "Optimized migration" from MS Access, MS SQL Server and Oracle.
"Optimized migration" is supported for the following:
Oracle8 .............. to be verified
Oracle9i ............. supported
Oracle10g ............ supported
Oracle10g R1........ supported
Oracle10g R2........ supported
MS SQL Server 7 ...... to be verified
MS SQL Server 2000 ... supported
MS SQL Server 2005 ... to be verified
MS Access 2000 ....... supported
MS Access XP ......... supported
MS Access 2003 ....... supported
MySQL 4.0 ............ supported
MySQL 4.1 ............ supported
MySQL 5.0 ............ supported
If you have tested against a different system please reply to this post.
The list of new features includes
- when migrating to a 5.0 server, VARCHARs are prefered over MEDIUMTEXT
The list of addressed bugs includes
- fixed missing mapping of MSSQL TEXT column type during data transfer
- Oracle DATE columns where missing time information during data transfer
- navigation was broken when the advanced mapping page was displayed
- when using the generic migration, indices with more than one column cause issues
- when object names (e.g. the target schema name) are changed on the manual editing page, the SQL code was not recreated
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Edited 1 time(s). Last edit at 08/12/2005 04:35PM by Michael G. Zinner.