Access to MySQL?

[Yodaheim]

I'm helping some friends migrate their site from the old classic .asp version that I created way back in '02 to a shiney new Python version.

The original site was running on a Access database and after all these years it's probably become the biggest Access db on the net!! (up to about 100 items added everyday).

I know there's an easy way to upscale Access to SQL Server, but is there and easy to upscale Accesss to MySQL?

 

[motivated]

There's no automated means I'm aware of for porting directly from Access to MySQL. Port the Access to SQL Server, then create an SSIS (formally DTS) package to port it to MySQL.

 

[danny]

You could do that or just write a script to loop through all tables on access, create them in mysql, then loop through all the records and populate them. I had to do something kind of like this with some stupid foxpro tables from a legacy system.

 

[imkazu]

If you have minimum table/columns I'd just dump your access db into a csv and write a php script to parse/import it, like danny mentioned

if you have lots of table columns, this becomes a hassle, and you could try motivated's route