Posted by Jim Michaels on 02/11/06 23:07

I've had perfect conversions with the MySQL Migration Toolkit (not tried it
with odd features of Access), available from the MySQL web site.
http://www.mysql.com/products/tools/migration-toolkit/ info
http://dev.mysql.com/downloads/migration-toolkit/1.0.html download

if you get any errors along the conversion, you can view the error detail &
edit the SQL and fix things. 10 minute process. not a toy tool. also
migrates Oracle and some others.
Can work directly from the database file - no need for odbc, unless you want
to. Generates a schema script and a data script.
had a database that used system tables. the toolkit decided to include the
needed system tables.

"Tim Roberts" <timr@probo.com> wrote in message
news:cmp0u193kvnsfnqf35nm1meomsg7dvl3v9@4ax.com...
> laredotornado@zipmail.com wrote:
>>
>>I am tasked with converting an MsAccess db to a MySQL 4 db in a Linux
>>environment. Can anyone recommend any good freeware/scripts to help me
>>do this?
>
> Googling for "access export sql" resulted in a MySQL hit first thing.
>
> The conversion is rarely perfect. Be prepared for some manual
> intervention. Standard practices in Access don't always line up with
> standard practices in MySQL. In particular, you will want to think very
> hard about any special characters in your table and field names. It's
> common to use spaces and dashes in Access field names, and it is possible
> to use them in MySQL, but it's inconvenient.
> --
> - Tim Roberts, timr@probo.com
> Providenza & Boekelheide, Inc.

[Back to original message]