MySQL Bugs: #67584: Workbench Crash migrating MS Access database

Bug #67584	Workbench Crash migrating MS Access database
Submitted:	14 Nov 2012 9:27	Modified:	5 Nov 2013 20:31
Reporter:	Dan Heron	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S4 (Feature request)
Version:	5.2.44	OS:	Windows (7 64bit)
Assigned to:		CPU Architecture:	Any
Tags:	access, crash, MDB

Description:
Workbench crashes every time I try to migrate a Microsoft Access database.

It crashes in the step "Reverse engineer selected schemata".

I have created a very simple Access database containing a single table and a single field.  I have tried different odbc drivers.  I have tried the following Access database versions:  2000, 2003, 2007.  It always crashes on the same step.

How to repeat:
1.  Create an Access database (.mdb file).

2.  Create an ODBC DSN for the database.

3.  Start MySQL Workbench and select "Database Migration"

4.  For "Database System" select "Generic RDBMS" from the drop down list.

5.  For "Connection Method" select "ODBC Data Source" from the drop down list.

6.  For "DSN" select the DSN that was created in step 2.

7.  Click "next", enter target details, click "next" again.

8.  The "Fetch Schema List" step completes successfully.  Click "next".

9.  Select the database to migrate.  Click "next".

10.  On the "Reverse Engineer Source" step "Connect to source DBMS" completes successfully.  However Workbench crashes during the "Reverse engineer selected schemata" step.

I have the same problem when migrating from access to MySQL.  My mdb file is more complex than yours but I do not think it does make a difference.  I tried everything with no success.  When migrating with the old migration toolkit everything went fine!!!  I do not understand why this piece of good and usefuk software has been discontinued.

Julian

I have the same issue. It is really frustrating. 

I am surprised that this is not working considering that the old tool did. Also, the download link for the old toolkit does not work anymore. Anyone knows where I can download it?

Windows 7 64 bit + Access 2010 crashes at the last step no matter which of the three options are chosen.

Hello.
Currently we do not support MS Access migration (http://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html).
I'll change the status of this bug as a feature request which will be analyzed for our team.
Thanks.

http://bugs.mysql.com/bug.php?id=67774 marked as duplicated of this bug.

In the mean time you can download the old Migration Toolkit from here: http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit

Migrations from Microsoft Access are still unsupported. The proposed fix makes Workbench not to crash when a user still tries to migrate from it. Now it shows an error stating that Microsoft Access is not supported yet.

Posted by developer:
 
FIXED.
Verified in:
Windows 7x64
Ubuntu 12.04x64
MySQL Server 5.6
WB 6.0.8.11345
Wb display a message for all unsupported DSN Options.

Fixed as of MySQL Workbench 6.0.8, and here's the changelog entry:

Migrating a Microsoft Access database would crash at the "Reverse Engineer
Selected Schemata" step. MySQL Workbench does not support the migration of
Microsoft Access, so the migration wizard will now display an error (and
halt operation) when attempting to migrate an unsupported database.

Thank you for the bug report.