fekaduw Posted February 19, 2007 Share Posted February 19, 2007 hello all, i had an access database which contain bulky data. now, am just planning to convert it by a mysql db. i've constructed the table but am not quite sure how i can migrate the bulky data i've in the access db to mysql. i tried to use a software but it didn't work out. any help is highly appreciated thanks Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted February 19, 2007 Share Posted February 19, 2007 There is a lot of different ways.... You can write a custom conversion script that will extract the data from Access and insert it into MySQL. You can export the data from Access, then, again using a custom script, insert it into MySQL. There is a MySQL ODBC connector that you can use to go directly between Access and MySQL, however your table structure would have to be EXACTLY the same for it work...and even then there is no guarantee. There is no easy way however...at least not without using some sort of conversion product...which probably isn't free. Make sure you have a back up of both databases before you try anything...... Quote Link to comment Share on other sites More sharing options...
fekaduw Posted February 19, 2007 Author Share Posted February 19, 2007 thanks but which tool do u think is appropriate. i mean the table structure is not similar. Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted February 19, 2007 Share Posted February 19, 2007 Write your own script.....it's the only way to be sure you are migrating correctly Quote Link to comment Share on other sites More sharing options...
fekaduw Posted February 19, 2007 Author Share Posted February 19, 2007 i don't have any idea of writing the codes my self. if u can provide me a sort of link to a tutorial or sample codes, i will be delighted Quote Link to comment Share on other sites More sharing options...
Barand Posted February 19, 2007 Share Posted February 19, 2007 Create a query in Access that fetches the data you want to export Export the query into a CSV file Use MySql "LOAD DATA INFILE .... " command to load the CSV data into your table Quote Link to comment Share on other sites More sharing options...
joder Posted February 19, 2007 Share Posted February 19, 2007 http://www.kitebird.com/articles/access-migrate.html http://www.google.com/search?sourceid=navclient-ff&ie=UTF-8&rls=GGGL,GGGL:2006-37,GGGL:en&q=migrate+access+mysql 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.