MySQL Bugs: #112529: Migration wizard in mySQL Community version not working

Bug #112529	Migration wizard in mySQL Community version not working
Submitted:	26 Sep 2023 21:15	Modified:	27 Apr 2024 12:26
Reporter:	steve birnbaum	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S3 (Non-critical)
Version:	8.0.33	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\SBirnbaum\AppData\Roaming\MySQL\Workbench\log\wb.log]

I am trying to use the Migration Wizard in Workbench Community to import .dbf tables from Visual FoxPro 7 into mySQL Server and keep getting the error "ODBC Administrator utility could not be found". I have made sure ODBC drivers are set up, PATH is correct, etc. When I try to set up .dbf files as the source in Migration Wizard, I choose "Generic RDBMS" as Database System and "ODBC Data Source" as Connection Method, but the dropdown list for DSN is empty. I go to ODBC Administrator where the ODBC Visual Foxpro driver shows up but then I get the error mentioned above.

How to repeat:
Try using Migration Wizard to import .dbf tables using an ODBC connection.

Suggested fix:
???

Hello Steve,

Thank you for the bug report.
Could you please provide sample .dbf tables. Please make it as private if you prefer.

Regards,
Ashwini Patil

I accidentally added too many sample .dbfs here to send to you and it is not giving me a "Submit" button because I guess total size is more than 50 MB and it will not let me delete any of the files I have attached. What do I do? Can you set something else up for me to attach files or tell me how to delete some?

contains 2 fields one numeric and one Memo which ios a pointer to the actual BLOB binary field

Attachment: bol00029.dbf (application/octet-stream, text), 1.85 KiB.

contains the actual BLOB binary image fields

Attachment: bol00029.FPT (application/octet-stream, text), 36.19 MiB.

index file for bol00029.dbf (not really important but must be present or you will get error trying to open dbf

Attachment: bol00029.cdx (application/octet-stream, text), 3.00 KiB.

here is test .dbf I have been trying to import (actually consists of 3 files that must go together, the .dbf, the .cdx, and the .fpt Memo fields in .dbd point to corresponding BLOB field in .fpt which contains binary image of a Bill of Lading for a delivery

I believe the reason Migration Wizard is not working is because Workbench 8 is 64-bit and a 64-bit ODBC driver for dBase/Visual FoxPro does not exist. Unless you know of a workaround for this, I don't think you need to spend any more time on it. Thank you for your help anyway.

Thank you for the details. Please try with latest version. Thanks.

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".