Access to MySQL – How hard is this going to be?

1160 pts.
Tags:
Data migration
Microsoft Access
MySQL
I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data migrated?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Odds are his application is going to be very complex if he’s been building it for 14 years.

This is probably going to be a very complex task.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ken Harthun
    It's true that he has a very complex set of databases, but at least all of the linking, query, and table structure, as well as the GUI (in Visual Basic) is known. Armed with that information, we should be able to build a MySQL structure that works with modules we plan to create under the ]project-open[ framework. It's possible that some other framework will suit our needs better.
    1,160 pointsBadges:
    report
  • Buddyfarr
    if you are familiar with databases then creating a MySQL DB to match the table structure he has in access should be the easy part. the hard part will be building forms to match the forms he currently has and then migrate the data into the new DB. Since it will be online you will probably need to build web pages to do this. PHP works well in this case. Just make sure that you do input validation so that SQL injections are not possible.
    6,850 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following