Re: Table missing from Access migration

[Michael G. Zinner]

There was a bug in the MS Access reverse engineering code that did not recognize multi-column indices. This has now been addressed and will be in the next release.

If you want to apply the fix right away, please open .\bin\windows\java\com\mysql\grt\modules\ReverseEngineeringAccess.java

Go to line 298 and add a new line
indexName = newIndexName;

So you get
index = new Index(table);
index.setName(newIndexName);
indexName = newIndexName;

Then recompile the .java file.

Instead you can of course open the Eclipse project that ships with the Migration Toolkit in ./java and apply the fix there.

Remember that you can remote debug the Migration Toolkit from Eclipse when you start it with the -debug option.

MySQLMigrationTool.exe -debug


For the missing data. Could you press the [Advanced >>] button on the Bulk Data Transfer page after the execution has completed? It should list all data select statements and errors that occur.


Further fixed the BIT and BYTE datatype mapping to TINYINT UNSIGNED. It will go into the next release.

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification