nick1 Posted September 22, 2006 Share Posted September 22, 2006 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 andI'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 simpleand painless as possible. Any recommendations on free tools to use?Thank you for your time,*Nick* Quote Link to comment Share on other sites More sharing options...
jvrothjr Posted September 22, 2006 Share Posted September 22, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.