Ms Access Data base conversion into mysql Server database

kausar ali
kausar ali used Ask the Experts™
on
I have Database in MS Access of my application and Now i want to convert into MySQL server database . Actually problem is that i have successfully import all tables by MySQL ODBC Driver. But there is some queries in access database and i am trying to convert into MySQL as views. when i am creating views from access databases query after change the query syntax as sql query . in some case the it will take too much time.
My main Question is that what is the best way to handle these access database queries in MySQL. is as Views or Store procedures or as Functions in MySQL server .please quid me and give me the right suggestion .

Thanks in advance
2017-05-12_2310.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
I don't see anything that would make the query slower in MySQL than in Access.  Make sure that all your foreign keys are indexed.

I don't use MySQL but for SQL Server, DB2, Oracle, Sybase, etc, I create views only when an Access query is slow and I create sp's only when a view is slow.
Vimal DMSenior Software Engineer

Commented:
@Kausar ali,

This should be helpful to you,
http://sunnyoasis.com/services/msaccess-convert-to-mysql.php

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial