Jump to content


Photo

Migrating an msAccess DB to MySQL


  • Please log in to reply
1 reply to this topic

#1 nick1

nick1
  • Members
  • PipPipPip
  • Advanced Member
  • 41 posts

Posted 22 September 2006 - 12:40 AM

Greetings,

Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database.
I'm already running Ubuntu 6 server with a LAMP installation.  The MySQL server is already up and running and
I've created some test databases.  The Access database is located on a Windows server.
I have full permissions to the Access database and the MySQL database.  I'd like the migration to be as simple
and painless as possible.  Any recommendations on free tools to use?

Thank you for your time,

*Nick*

#2 jvrothjr

jvrothjr
  • Members
  • PipPipPip
  • Advanced Member
  • 300 posts
  • LocationOhio

Posted 22 September 2006 - 05:39 PM

you could use SQLyog with the OBDC driver from mysql to connect to the Access DB and create a SQL file then with the same software connect to the mysql DB and run the sql file to import it into mysql.

I have used this process before to do this.


If you understand everything you know nothing!

http://rcchjr.awardspace.com/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users