Migrating from Access to MySQL - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Weasley · 12-23-2009, 04:25 AM

Microsoft Access is a popular data management application that allows you to store information in tables that it manages directly from the local disk.

But still people finds a lot of reason for migrating to MySQL. The MySQL database system is one such storage manager; if you install the MyODBC driver, Access can make ODBC connections to MySQL database servers over the network. You can still use the contents of your tables through Access, but the tables themselves are hosted by the MySQL server.

If you are facing any trouble in migrating, I hope the following content will prove useful to you ..

eZdia : Learn Share Advise

Robinson · 02-11-2010, 02:52 AM

I always face trouble in migrating , Lets see how your content on Ezdia can help me in this...

nice123 · 02-22-2010, 04:28 PM

Best tool I found for migrating is DataPro - dataPro | Database software | Database conversion | Data Migration

Saved me a lot of time and trouble.

Charming · 02-23-2010, 04:08 AM

thanks for this guys

shumaker212 · 03-04-2010, 06:16 AM

I Use dbload for such aim, its a tool to migrate database

Find Here: www(.)dbload(.)com

jesse.rogers123 · 03-17-2010, 07:03 AM

Migrating is a highly complicated aspect. but migrating from MS Access to MySQL will not be much of a problem as MS Access has essentially much less datatypes than MySQL. However, migrating from MySQL to MS Access will lead to a huge loss/change in database schema. Hence during database design a programmer must take into account adaptability/ future migration issues as often migration often includes schema changes to extract the full use of the destination database

tomason · 02-11-2011, 11:40 PM

I want to help you. You can search the Spire.DataExport on the Internet.