Forums: Back End:

Hi,
Sorry quick question. If I've already got all my ASP code to work with an Access database which is all populated how hard will it be to move the database from Access to MySQL?
Will I have to recode everything or just the connection string?
Is it just as easy to set up a MySQL database as it is an Access one?
Cheers,
Suzy

They both use a form of SQL (obviously), but AFAIK neither is ANSI standard compliant so each has its own minor peculiarities and you might find that you need to make a few changes.

Here's some freeware that claims to help in the process of migrating between Access and MySQL databases.

Some info from MySQL -- skip the marketing pitch and start reading at 'Planning For Your Migration'.

As for setting it up, well I've never set up an Access database but I don't remember it being particularly hard to get MySQL up and running. If it's web-based then you're going to want to install PHPMyadmin, which does lets you do most of the day-to-day admin you'll need to. Also, MySQL gives away various tools that between them do much the same thing.

If you have any specific questions, just shout.