Transfer databases

[evergreean]

I currently have an Access 2000 database that looks like it will work but was wondering how much work will be needed in future to transfer this database to a MySql database?

It has 3 relational tables with about 12000 records.
Is there a tool that can transfer the schema and records from Access to MySql?

 

[snowboardr]

I use mysql front to do that, however i dont have a copy on hand wish i could help you on that. I would try searching for it, Im pretty sure mysql.com has something like that...

oh i just found a tutorial on mysql.com for this:

http://dev.mysql.com/doc/refman/4.1/en/export-of-data.html

Google search:

http://www.google.com/search?hs=CuL...fficial&q=convert+access+to+mysql&btnG=Search

http://www.google.com/search?hs=YJ1...S:official&q=free+access+to+mysql&btnG=Search

Site San Diego www.sitesd.com

 

[Kozusnik]

I've exported the tables from Access as csv files, then imported into mysql. I think mysql can do that natively now.

SELECT * FROM management WHERE clue > 1
> 0 rows returned

--ThinkGeek T-Shrit