Bug #25035 MySQL Migration Toolkit
Submitted: 13 Dec 2006 10:55 Modified: 17 Dec 2006 11:07
Reporter: Lloyd Saldua Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.1.6/1.1.7 OS:Windows (Windows XP Professional Edition)
Assigned to: CPU Architecture:Any

[13 Dec 2006 10:55] Lloyd Saldua
Description:
I have an access database (.mdb) which I currently used, and it contains employee information including employee pictures.  The fieldname structure of my database (naming only two) address => Memo and the photo => OLE Object.  I want to migrate to MySQL Server so I used MySQL Migration Toolkit 1.1.6, but the problem was, after I migrated to MySQL Server, the fieldname photo of my database doesn't have a value anymore.  When I browse it in a Query Browser, the fieldname "address" contains a magnifying glass icon and a disk icon, which appears if the datatype you declared is BLOB in MySQL.

Only the photo field doesn't have a value, and I wonder why the magnifying glass & disk icon appears on fieldname address which is a LONGTEXT datatype.

How to repeat:
I have an access database (.mdb) which I currently used, and it contains employee information including employee pictures.  The fieldname structure of my database (naming only two) address => Memo and the photo => OLE Object.  I want to migrate to MySQL Server so I used MySQL Migration Toolkit 1.1.6, but the problem was, after I migrated to MySQL Server, the fieldname photo of my database doesn't have a value anymore.  When I browse it in a Query Browser, the fieldname "address" contains a magnifying glass icon and a disk icon, which appears if the datatype you declared is BLOB in MySQL.

Only the photo field doesn't have a value, and I wonder why the magnifying glass & disk icon appears on fieldname address which is a LONGTEXT datatype.

Suggested fix:
Much better if MySQL Migration Toolkit can migrate a database even if it has an images stored on it.
[14 Dec 2006 17:43] MySQL Verification Team
Thank you for the bug report. Could you please provide a sample database
(just with 1 record) to test in our side. Thanks in advance.
[15 Dec 2006 11:07] MySQL Verification Team
Thank you for the feedback.
[17 Dec 2006 11:07] Michael G. Zinner
Hi,

OLE fields cannot be migrated due to limitations of the Java JDBC/ODBC bridge. This cannot be fixed.

--

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.