Jump to content

From Access to MySQL


jornamon

Recommended Posts

Hi,

 

I have a database in MS Access. I\'m plannig to migrate to mysql (and php for forms and repots). I used access at first time, but now the database is getting bigger, and I am already using an apache+php+mysql server for the TUTOS Team organization software and I want to serve both the TUTOS database and the marketing database from the same server.

 

Can anybody give my a clue on how can I achieve this without much pain ?

 

The important thing is the data. The structure isn\'t so much because I\'m thinking about changing it.

 

Tools, links, tutorials, webs, advice,... everything will be greatly appreciated.

 

Thanks in advance.

 

Jorge

Link to comment
Share on other sites

here is a pretty good link

 

http://pgadmin.postgresql.org/pgadmin2.php...hp?ContentID=15

 

if you want to save the data but change the structure at some point your going to need some software that is customized to both the specific structure of your current and future structure. This isn\'t really a difficult task if you have some programming experience with PHP. PHP has a specific interface with obdc that can be use to get the data a seperate mysql interface to create and store the data in any changed form you want. If your in a hurry and don\'t have the PHP experience then shoot me an email and I can give you was information I need to write the code.

 

mmabe@hot.rr.com

Link to comment
Share on other sites

I think I could manage with that link. Moreover, during the time between out posts I\'ve found some more converting tools here http://www.mysql.com/portal/software/conve...tors/index.html

 

I think I should success with at least one :D .

 

About the changes in the structure I hope they aren\'t going to be very hard, because the database is now going to be used for a narrower scope, and basically I only need to drop some tables. I think I\'m going to do this with Access and the use a migration tool to create the new db.

 

Thank you very muc for your help and for your offer. I really appreciate it.

 

Jorge

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.