Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Software
Register

Reply
 
LinkBack Thread Tools
Old 27.09.2002, 20:36   #1
Младенец
 
Join Date: 09 2002
Location: Moscow
Posts: 23
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Post 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
Reply With Quote
Old 27.09.2002, 23:13   #2
Главный Лысый
 
Pascal's Avatar
 
Join Date: 10 2001
Location: AM
Age: 39
Posts: 2,829
Downloads: 4
Uploads: 0
Reputation: 28 | 4
Post

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

----------------------------------------------------
Лысина - это полянка, вытоптанная мыслями.
----------------------------------------------------
Reply With Quote
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 07:02.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.