Re: Access97: Not all tables copied

[Paul Hampson]

I have had problems migrating tables from an Access 2000 database to a MySQL 5.0.4 database using the 1.05 migration toolkit. I found that out of 40 tables only 26 were created, although there was not indication of a problems in the summary, there were a number of errors in the log during the process when it creates the objects.

On the 14 tables which were not created, all but one was because of a duplicate index. I checked the access file and apparantely this is because access produces index names for Foreign keys in terms of the following structure:

'origintablenamethistablename'

The migration toolkit has a problem deciding whether they are two indexes or a multi field index. The migration toolkit makes two separate Index declarations but keeps the same name for both.

In addition, apart form the abysimal rate of success in migrating the data, there was a similar lack of success in terms of defining fields as NOT NULL with 174 of the NOT NULLS in my datbase ebing explicitly NULL after migration

Has anybody else found similar problems?



Edited 1 time(s). Last edit at 05/13/2005 07:45AM by Paul Hampson.