Question Access to MySQL

[Stitcho]

Im currently looking at converting an Access database to MySQL and I have been reading bits and pieces on the internet about how to do it but im a little confused to the best route to take.

Its only a very small database with 3 linked tables that tracks membership details of a club but I need to convert it so that it is available online in a PHP front end with a MySQL backend. I have read there is software to do this converstion but I dont know which is best to use. Has anyone done this type of conversion before? What do I need to take into consideration when doing the converstion (i.e. difference in field formats, etc)?

Thanks

Dave

 

[Banana]

MySQL has an article detailing the upsizing process.

I've never used any of those products, as I just link to MySQL.

 

[Stitcho]

MySQL has an article detailing the upsizing process.

I've never used any of those products, as I just link to MySQL.

I've just read through that article which has helped but im a little unsure of which programs to use to do the conversion and unfortunately I dont have the time for trial and error like I normally do as I have a very short deadline on this project

 

[Banana]

My next advice would be to try DevShed.com's MySQL forum.

Sorry.

 

[Stitcho]

My next advice would be to try DevShed.com's MySQL forum.

Sorry.

Thanks i'll take a look

 

[ErikSnoek]

MySQL has a tool called "MySQL Migration Toolkit", it does all the work for you (creates the tables in MySQL, transfers data from MS Access to MySQL etc.)

 

[Stitcho]

Thanks, I'll take a look at that some time.
I have actually decided not to convert the database I am using now and have created a new database from scratch and then do a data migration, mainly because I am changing the structure of the DB