• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

ms access db to mysql linux

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi,
Do you know what would be the easist way to implement or solution to have a mysql db from ms access db? or have to do mysql db from the scratch?
any hints?
 
Ranch Hand
Posts: 285
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are a number of ways you can achieve this, if you goto the mysql sofware contribution page, there are some VBA functions which produce SQL files from an access database. You can then import these into your MySQL database. (I thouhgt I'll save you the hassle and provide a link: http://www.mysql.com/portal/software/item-98.html)
There are commercial tools which allow this too (here is one: http://www.realsoftstudio.com/sqlporteraccess.php)
In our workplace a popular app was written in access some years ago and due to growth it kept falling over and as a quick fix, I created linked tables so the application thinks its talking to its same old Access table but these are pointing to MySQL behind the scenes.
I hope this helps.
 
Rema Remulta
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the good input and the nice link that you gave that enables my Access db to be converted on MySQl db. It's really cool tool and indeed very easy to do!
But actually, this is just half of the solution of my problem, we need basically to convert our Access db to MySQl db to be run on Linux. Since i don't have experience yet on linux environment, the first consideration was to let myself known of the MySQL Windows. Now that i've already converted my Access db to MySQl db (windows), the next problem would be how to have this MySQL db (windows)on MySQL linux? I assumed that there would be not so much problem on deploying this since they are the same MySQL but just on different platform, but i am not sure of course. My next approach would be installing MySQL on linux and i'll see and try how to solve it. If you have any hints, further suggestions to this that would make things a little easier, i would be grateful to have them.
Thanks,
Rema
 
Faisal Khan
Ranch Hand
Posts: 285
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rema,
Sorry if this reply is far too late to be meaningful. From my experience of doing a port from windows to Linux the only thing you have to be careful about is the naming of the tables due to case sensitivity on linux and not on windows.
For example a table called Faisal_Test on windows can be called from a query as select * from faisal_test however, under Linux, tables Faisal_Test and faisal_test are two different tables.
The reason behind this (as you may already know) is that MySQL stores all the databases and the tables in files on the filesystem under <MySQL_HOME>/data/<database_name>/<all the files of your tables>
I hope this helps.
- FK
[ July 25, 2003: Message edited by: Faisal Khan ]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic