Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Answer: Transferring an Access Database to mySQL

by maverick (Curate)
on Jun 06, 2001 at 02:38 UTC ( #86050=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Transferring an Access Database to mySQL - Answer contributed by maverick

I (and our local Access god) had to do this for a project a couple of months ago. We weren't just cloning the database, we were also changing the structure. He exported the tables to csv files, I wrote some perl to do things like translate the date, time, and boolean formats from MS to MySQL.

Because there isn't a perfect 1 to 1 mapping of data types between Access and MySQL, and we were restructuring the database, we found it easier just to csv export and then 'load data infile' into MySQL. You might also consider this route if your servers aren't network to each other.

The downside is you have to do this one table at a time...it would suck if you had 100's of tables :)

--/\/\averick

  • Comment on Answer: Transferring an Access Database to mySQL
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[LanX]: and I'm sure I read that *hotel* used to be pronounced 'otel by the English upperclass
[Your Mother]: American English vowels are pretty lazy/mumbly in general.
[LanX]: talking about antisemitism, youtube automatic subtitles is entertaining shocking sometimes ... like when offering "Fruit Jews" as a drink
[Your Mother]: ...Come on you King of the Juice...
[Your Mother]: I actually know his kids.
LanX has to go/
[Your Mother]: King Herod's song (Mike D'Abo performed, I think)

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (10)
As of 2017-03-27 17:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (320 votes). Check out past polls.