Re: Access97: Not all tables copied
Posted by: Paul Hampson
Date: May 12, 2005 06:34AM

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.

Options: ReplyQuote


Subject
Written By
Posted
April 22, 2005 08:26AM
April 22, 2005 11:12AM
April 26, 2005 04:01PM
April 26, 2005 04:03PM
April 29, 2005 10:36AM
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.