Re: [Sheflug] Access to MySQL

[Ruth Gunstone <ruth [at] xxxxxxxxxxxxxxxxxxxxxxxx>]

In message <3EEB535B.6020708 [at] sirtis.org.uk>
          Jonathan <jonathan [at] sirtis.org.uk> wrote:

> Richard Ibbotson wrote:
> > Hi
> > 
> > I've been asked to migrate an Access "database" to MySQL.  Not done this
> > before and so I can't comment on what might be possible. Searched the net
> > with Google but can only find winduhs based software that will do the job
> > for me.  I suppose I could use that.
> > 
> > Anyone know of any GNU/Linux based software that will convert access to
> > MySQL ?
> 
> What sort of data do you have? Any chance you could export to CSV and 
> import from there?
[snip]

That's virtually what I did when I had a similar task last year. Fortunately,
the Access database wasn't too complex (just a few (large) tables, and no
'relationships'), so exporting from Access as TAB-separated files, then
importing to MySQL using LOAD DATA worked a treat. I did need to manually
clean-up the TSV file, which contained some excess TABs and other oddities
which seemed to upset MySQL.

-- 
Ruth Gunstone          (ruth at bolsterstone dot demon dot co dot uk)

 /====================================================\ 
 ||  "That's the trouble with Time Travel - I can    ||
 ||     remember tomorrow as if it were yesterday."  ||
 ||                       The Doctor                 ||
 ||                       "Death Comes to Time"      ||
 \====================================================/
___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.