Re: Table missing from Access migration
Posted by: Michael G. Zinner
Date: May 25, 2005 12:09PM

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\

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

So you get
index = new Index(table);
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.


Michael Zinner, Team Lead, Developer Tools

Are you MySQL certified?

Options: ReplyQuote

Written By
Re: Table missing from Access migration
May 25, 2005 12:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.