How to convert databases from Access to MySQL

iceberg · 27.09.2002, 19:36

Jhoghovurd jan , karogha mi hat cragir imanaq vor karoghanam MS Access-i [email protected] convert anem MySQL Database sarqem

Pascal · 27.09.2002, 22:13

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

27.09.2002, 19:36	#1
iceberg Младенец Join Date: 09 2002 Location: Moscow Posts: 23 Downloads: 0 Uploads: 0 Reputation: 0 \| 0	How to convert databases from Access to MySQL Jhoghovurd jan , karogha mi hat cragir imanaq vor karoghanam MS Access-i [email protected] convert anem MySQL Database sarqem Share Share this post on Digg Del.icio.us Technorati Twitter

27.09.2002, 22:13	#2
Pascal Главный Лысый Join Date: 10 2001 Location: AM Age: 43 Posts: 2,829 Downloads: 4 Uploads: 0 Reputation: 28 \| 4	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 Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Ruben Muradyan Technical Director PanARMENIAN Network: Armenian News ---------------------------------------------------- Лысина - это полянка, вытоптанная мыслями. ----------------------------------------------------