How to convert databases from Access to MySQL

iceberg · Sep 27, 2002, 19:36

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

Pascal · Sep 27, 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

Sep 27, 2002, 19:36	#1
iceberg Младенец Join Date: Sep 2002 Location: Moscow Posts: 23 Rep Power: 0 Reputation: 10	How to convert databases from Access to MySQL Jhoghovurd jan , karogha mi hat cragir imanaq vor karoghanam MS Access-i database-@ convert anem MySQL Database sarqem

Sep 27, 2002, 22:13	#2
Pascal Главный Лысый Join Date: Oct 2001 Location: AM Posts: 2,829 Rep Power: 7 Reputation: 38	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 __________________ Ruben Muradyan Technical Director PanARMENIAN Network: Armenian News ---------------------------------------------------- Лысина - это полянка, вытоптанная мыслями. ----------------------------------------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode