[Sussex] Access migration to MySQL help, please?

[Mark Harrison]

Ooh - thanks for the offer.

Sadly, I don't have access (sic) to the machine in question, so it's a
question of the existing user "taking a copy and sending to me" :-(

M.

----- Original Message -----
From: "Geoffrey Teale" <tealeg at member.fsf.org>
To: <sussex at mailman.lug.org.uk>
Sent: Friday, February 28, 2003 6:20 PM
Subject: Re: [Sussex] Access migration to MySQL help, please?


> 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
>
>
>
> _______________________________________________
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/sussex