Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Go Back   Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more > Web Programming > Databases - MySQL, SQL, Oracle, Access and others
User Name
Password

Reply
 
LinkBack Thread Tools Display Modes
Old 12-23-2009, 03:25 AM   #1 (permalink)
Weasley
Member
 
Join Date: Dec 2009
Posts: 100
Default Migrating from Access to MySQL

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
Weasley is offline   Reply With Quote
Sponsored Links
Old 02-11-2010, 01:52 AM   #2 (permalink)
Robinson
Junior Member
 
Join Date: Jan 2010
Posts: 94
Default Re: Migrating from Access to MySQL

I always face trouble in migrating , Lets see how your content on Ezdia can help me in this...
Robinson is offline   Reply With Quote
Old 02-22-2010, 03:28 PM   #3 (permalink)
nice123
Junior Member
 
Join Date: Jan 2010
Posts: 22
Default Re: Migrating from Access to MySQL

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

Saved me a lot of time and trouble.
nice123 is offline   Reply With Quote
Old 02-23-2010, 03:08 AM   #4 (permalink)
Charming
Junior Member
 
Join Date: Feb 2010
Posts: 17
Default Re: Migrating from Access to MySQL

thanks for this guys
Charming is offline   Reply With Quote
Old 03-04-2010, 05:16 AM   #5 (permalink)
shumaker212
Junior Member
 
Join Date: Mar 2010
Posts: 1
Default Re: Migrating from Access to MySQL

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

Find Here: www(.)dbload(.)com
shumaker212 is offline   Reply With Quote
Old Yesterday, 06:03 AM   #6 (permalink)
jesse.rogers123
Junior Member
 
Join Date: Nov 2009
Posts: 5
Default Re: Migrating from Access to MySQL

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
jesse.rogers123 is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Points Per Thread View:
Points Per Thread:
Points Per Reply:



» Sponsors

» Links

» Affiliates
Web Hosting
Online Backup Reviews
Marketing Find
Merchant Select
SiteMap Builder
Host Compare

» Links

» Sports Network
Paintball Forum
Football Forum
Hockey Forum
Golf Forum
Boxing Forum
Lacrosse Forum
Baseball Forum
SnowBoarding Forum
Soccer Forum
MMA Forum


All times are GMT -4. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.0.0 RC8
Webmaster Forums