PHP MS Access to MySql

I have php application that is database driven and it is currently a MS Access database... i would like to migrate to MySql...

I would like to know if there is an easy was to change existing code that interacts with a MS Access database to do the same with a MySql database... (the MS Access database is going to be transferred to MySql)

so.... i know how to transfer the database, just wanting to know about the code (it currently uses ODBC connection and commands)
LVL 6
0791882310Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

syedasimmeesaqCommented:
not sure if I understand your question right. If you are transferring it to mysql, make exact same tables with field names and types and then use odbc in msaccess to link to that tables. Then you can write an append query to append the data into those linked tables.
As far as application itself goes, you are gonna have to write code in any scripting langauage of your choice. I prefer php to do queries and stuff, if you want it webbased
now if you wanna use ms access as front end then just have the data in mysql transferred and use link tables with your current codes
hope this helps
0
0791882310Author Commented:
let me try to explain better.... currently i have a PHP application that uses an Access database, i already know how to move (migrate) the data to MySql, i just wont to have to rewrite all the code from communicating with access to MySql.... soooo.... i was wondering is there something that will scan the php files i have, and replace all the ODBC commands and replace them with the equivalent MySql commands?
0
0791882310Author Commented:
also, if i were to just link the sql tables in access and keep all the same php code, will i still have the limitations that access has?
0
syedasimmeesaqCommented:
I am sure that if you use access as the front end, the limitations will still be there by access. I dont know of any software that will do what you want to do unless u use some kind of editor (dreamweaver) for replace function. You will still have to do manual work on that.
Sorry
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
0791882310Author Commented:
well that sucks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.