ACCESS to MySQL 4.0

[SendTrash]

currently the website setup is using ASP with a ACCESS database backend (using ODBC)

I just wanted to know if it is possible to move from access to mysql (is there an odbc api for mysql?)


Doesn't odbc let you use any database that also has an odbc interface?

What are the migration issues that would occur?

 

[bunker]

I've never used MySQL, but any db that has an odbc driver can be used with ASP, and seeing as MySQL is somewhat popular I would have to assume there is an odbc driver for it.

 

[bevancoleman]

There is an ODBC interface for mySQL, it's called myODBC.

Yes you can migrate from access to mySQL, however you may have issue with differences in feature sets. The biggest change is likly to be RecordCount, on most server based databases the behaviour of this command changes (it will return -1 in many cases, indicating that it is unsupported).

However over all there shouldn't be major problems, just make sure you check that everything works before it goes live.

 

[gopunk]

http://www.cynergi.net/exportsql/