MySQL Forums
Forum List  »  Microsoft Access

Migrate from Access 2010 to MySQL5.6 via ODBC?
Posted by: Ian Hingley
Date: November 15, 2013 05:48AM


Total MySQL newbie here.

15 years experience with SQL Server though.

Trying to migrate an Access 2010 database to MySQL5.6
I've spent ages trawling the web on this one.
Some say just use ODBC
Some say you need a 3rd-Party tool
Some say it used to work but doesn't any more.

I'm trying the ODBC route. There's a migration wizard which claims to connect to Generic RDBMS, so I assume this should work.

Here's how far I get:

Create an ODBC datasource to the Access database.
Start the MySQL Migration Wizard.

Source database system = Generic RDBMS
Connection Method = ODBC Datasource
Pick my datasource name, Test Connection OK, click Next.

Target Stored Connection = Local instance MySQL5.6
Test Connection OK, click Next.

Fetch Schemata List, click Next.

Schemata Selection
Dialog shows Catalog/Schema showing the path and the mdb file name.
Below that there is a circular database symbol with mdb.none
I click to Include these and click Next.

Within seconds of opening the Reverse Engineer Source screen, I get a fatal 'MySQL has encountered an error' message and MySQL crashes out completely.

Can someone point out what I'm doing wrong please? I seem to have wasted a lot of time on this.



Options: ReplyQuote

Written By
Migrate from Access 2010 to MySQL5.6 via ODBC?
November 15, 2013 05:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.