Re: Access97: Not all tables copied
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.
Subject
Written By
Posted
Re: Access97: Not all tables copied
May 12, 2005 06:34AM
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.