MySQL Bugs: #27491: ODBC Reports Unable To Migrate

Bug #27491	ODBC Reports Unable To Migrate - Too Many Records
Submitted:	28 Mar 2007 7:49	Modified:	15 Jun 2007 10:46
Reporter:	Paul Rudge	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	Falcon 5.2	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	migration, MSAccess, ODBC

Description:
Migration Toolkit does a wonderful job of interpreting the MSAccess tables (one the MS objects were administered) but on doing a bulk upload, it did not transfer any records from large tables. Zero reported in MYSQL.

Of The 1GB Data - 250Mb is in these 6 tables (54 in total)

Possible due to the InnoDB default!

Tried BOTH ODBC Ver 5 and 3.51

How to repeat:
Would not upload data - did not report any errors, Table specs OK - just NO data

Had to do a manual export out of MSAccess Then set up indexes, field types - a real drag.

Suggested fix:
Don't know wether it was a problem with the Migrator or MSAcess

Possible memory restrictions.

Thank you for the report.

After executing update, if you click on "Advanced" button in the "Bulk Data Transfer" window, it should show Message Log of transfer. Please upload this log to we can examine what happened.

Also in previous screen, check "Create Script File for Insert Statements" checkbox and try to upload this file to the database and report about errors if they occur.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".