[Sussex] Access migration to MySQL help, please?

Geoffrey Teale tealeg at member.fsf.org
Fri Feb 28 18:29:02 UTC 2003


Chaps,

If it's a one off the simplest way to do this is to make a copy of the
Access .mdb file and just go through doig Ctrl-A and then Delete - you
may hit a few problems with relationships - but if the person who made
the DB is non technical you probably won't at all.

Alternatively you could use a tool like DataArchitect or (the vastly
more expenisve) ERStudio of the (hideously, grossly expensive) ERWin to
do this for you.  

I have Data Architect for Windows/Linux as I don't have it installed
anywhere right now (and the license stipulates I can have it installed
on any one machine at any given time) I don't think there would be a
license problem with you installing it and using it for a day or so...

.. it's pretty flakey compared to the likes of ERStudio and ERWin, but
it would give you a nice diagram of the database, and if you're lucky it
could even recreate it in MySQL for you!

-- 
tealeg at member.fsf.org
Free Software Foundation






More information about the Sussex mailing list