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* Link to comment https://forums.phpfreaks.com/topic/21602-migrating-an-msaccess-db-to-mysql/ 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. Link to comment https://forums.phpfreaks.com/topic/21602-migrating-an-msaccess-db-to-mysql/#findComment-96856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.