MySQL Bugs: #14595: Migration report confirms data transfer however tables are empty

Bug #14595	Migration report confirms data transfer however tables are empty
Submitted:	2 Nov 2005 23:03	Modified:	5 Dec 2005 13:38
Reporter:	Alphonse Hoge	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.0.20-rc	OS:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any

Description:
The complete migration process goes through with only the one error shown bellow.

"The views cannot be reverse engineered because the MS Access system tables cannot be accessed. Take a look at the manual to enable access to the system tables. [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'."

NB. This is an old database where the original user/pwd are no longer known.
Access Database is functional but I cannot alter permissions for MSysObjects at this stage. We are still trying to resolve this.

The Migration report shows that the bulk transfer has moved data for each and every tables

All the tables are created and look correct.

>>>> However only 1 table out of the 41 tables imported has data <<<

MySQL server version 4.0.18nt running on XP platform
Microsoft access driver version 4.00.6019.00

How to repeat:
This occurs every time I attempt to migrate the database.

Why you think it is a bug of MySQL Migration Toolkit if you
know that can't access the sysobj which need the user and
password required for not to get permission denied. ?

Looks to me an expected behavior. I am able for to
migrate Access DB without any problems when I have
the required privileges.

Thanks in advance.

Hi Miguel
As I mentioned in the issue I know there is problem that has to be resolved. What is misleading is that the migration report "data bulk transfer" section clearly states that data was transfered 
    360 row(s) transfered.
    2069 row(s) transfered.
    842 row(s) transfered.
    etc etc
and I therefore expected data to be present in the tables.

I have a similar problem.  

I am attempting to migrate a MS SQL Server 2000 DB (Development Version) to MySQL 5.0 using the MySQL Migration Toolkit (Winows XP).  Several of the tables are empty after the process is complete.  

In each case the message is as follows with specific references to the table and column.  The column data type in question is floating point in SQL Server and no mapping errors are given during the migration process.  In the case of this table the message indicates that 86 rows were transfered, but zero rows actually were transfered.

`E-T_LeadsApp_dbo`.`ET_Leads_Data_Import`
      ----------------------------------------- 
          Data truncation: Out of range value adjusted for column 'LeadsRating' at row 3
          86 row(s) transfered.

This is indeed a bug.  MT is incorrectly reporting that the data migration completed successfully.

I am using win2k and a MS Access db.  After migration the report states that around half of the rows of the original table were transferred and because of a duplicate key it could not continue.  (?)  But the tranferred table doesn't show any row.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html