Description:
I have some Access databases with tables and their relations. To migrate the databases from access to MySQL I used the old migration tool and it worked almost perfect except it does not establish the not null (required in access) property of the fields correctly. Since that tool has been dicontinued I am now trying to do the same with the workbench vesion 5.2.44 CE but it always crashes in the middle of the proccess when starting the reverse engineering step.
I have: Windows XP Pro SP3 OS + MySQL 5.5 server + Microsoft windows office 2007 (also tried 2003) + MySQL ODBC connector 5.1 driver
How to repeat:
1. Select an Access database (.mdb file).
2. Create an ODBC DSN for the selected access 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 and quit the application abruptly.
Suggested fix:
I have not found so far a solution for this bug
