Migrating Access databases to MySQL

Post by **Patrick** » Tue Nov 22, 2005 2:28 pm

Easy to do now with this freeware app:
http://www.bullzip.com/products/msa2mys/info.php

An this:
http://dev.mysql.com/downloads/migratio ... t/1.0.html

Chess · Post by **Chess** » Tue Nov 22, 2005 3:50 pm

wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

P.S. I like the Iron Maiden avatar, Pat. Powerslave, right? I had that circa 1984 I believe.

Linc · Post by **Linc** » Mon Nov 28, 2005 1:26 pm

Chess wrote:wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

P.S. I like the Iron Maiden avatar, Pat. Powerslave, right? I had that circa 1984 I believe.

Well, I haven't used any of those but there is a package called mdb tools that I have been using with great success for quite a while now to yank data out of client-supplied db's so that I could use it. You can find info here: http://mdbtools.sourceforge.net/

Jza · Post by **Jza** » Tue Nov 29, 2005 5:55 pm

MDB-Tools lets you use Access which is crap. Why will you want to mantain Access databases with limited tools. I would just rather use a real database in MySQL.

Jza · Post by **Jza** » Tue Nov 29, 2005 5:56 pm

Chess wrote:wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

I have, and it works great.