How to convert databases from Access to MySQL

[iceberg]

Jhoghovurd jan , karogha mi hat cragir imanaq vor karoghanam MS Access-i database-@ convert anem MySQL Database sarqem

[Pascal]

http://www.mysql.com

Kachaesh ottuda MyODBC. Installiruesh kak napisano v ego Readme. Sozdaesh system DSN, v kotoriy propisyvaesh vse credentials(username, password, etc). Potom v Accesss sozdaesh noviy ODBC table, ukazyvaya etot DSN, i perekachivaesh dannye mezhdu dvumya tablicami uzhe vnutri Access.

Tut est' neskol'ko nuansov. Esli ty ne ispol'zzuesh Innobase tables v Mysql, to analoga "Field relationship" v Access ty ne poluchis. YA dazhe ne znayu POdderzhivaet li ODBC takie ponyatiya. Est' eshe nesovpadeniya v tipakh poley v Access i Mysql. Odnim slovom esli ty ne proektiroval bazu pod Mysql, a iznachal'no proektiroval ee v Access - to mozhet vylezti OGROMNOE kol-vo problem. Ili ne vylezti nikakikh. Edinstvennoe chto mogu garantirovat' chto VSE dannye ty perenesesh. A vot obespechivaemye Access-om ssylki, svyazki i prochuyu mut' - mozhet i net.

Regards