MySQL Bugs: #25035: MySQL Migration Toolkit

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

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.

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.

Thank you for the feedback.

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.