Re: Database migration from Access97 to MySql (and eventually to Linux) - peterblaze - com.mysql.lists.win32

5 messages in com.mysql.lists.win32Re: Database migration from Access97 ...

From	Sent On	Attachments
John D. Herron	12 Feb 2004 08:34
peterblaze	12 Feb 2004 15:04
Petr Vileta	13 Feb 2004 01:32
Lahu	14 Feb 2004 10:31
Russ Myrick	14 Feb 2004 21:00

Subject:	Re: Database migration from Access97 to MySql (and eventually to Linux)
From:	peterblaze (pete...@poczta.onet.pl)
Date:	02/12/2004 03:04:17 PM
List:	com.mysql.lists.win32

Hi,

I'm not a 'big fish' in MySQL but in my own firm I migrate from huge MS Access database (description of thousands of images in linked tables) to simpler and very efficient MyISAM tables, At the beginning I suggest two steps: 1) download DBDesigner4, it's open source tool for database modelling written for MySQL. I've used its 'reverse engneering' tool to import my MS Access database schema and raletionship between tables to create efficient MySQL database schema (link: http://www.fabforce.net/), 2) YOU MUST carrefully chack data types definition on every columnt on every created MySQL tables. Data types may be different in MS Access and MySQL so You must check for possible data loss (data truncation),

QUICK TIP: For quick, first step testing, download odbc driver: MyODBC 3.51 from www.mysql.com, create system DSN, create testing database in MySQL and export You tables and data to MySQL directly from MS Access by choosing 'Export AS" using defined ODBC DSN, than look at MySQL tables using MyCC or DB Designer or another MySQL GUI,

HTH, peter John D. Herron wrote:

Hello, everybody.

Current work environment is a stand-alone Pentium 4 2.0 GB machine with 512 MB RAM set up to run

a) Windows 98SE w/ an Access 97 database (as part of MS Office 97 SP2) holding some 12 essential tables (for customer relations + order management in four languages) plus related forms (not essential), reports (essential, for bills + statistics) and queries (essential), on one harddisk; none of the tables/queries have more than 900 records. b) SuSE Linux Pro 8.2, installed on a second, dedicated harddisk.

The idea is to gradually move the Access material to a MySql environment (first on the Win98SE side in order to gain familiarity with MySql, but ultimately onto Linux) as a prelude to giving up most of the MS environment altogether.

I need advice on the proper sequence to follow in order to get MySQLCC (or some other GUI with similar functions) to interact with MySql (or vice versa), especially with regard to the interplay between the DOS command interface and the CC interface.

I've consulted the MySql manual looking for some plain-language, clear-cut, step-by-step directions that would apply to my situation, but I must admit that with all the jumbled stuff in there trying to address everyone's concerns I got rather confused and lost. Maybe I'm just too stupid, or getting too old (around 66) for this kind of exercise ?

Thanks for any help any of you might send this way. jdh

____________________________________________________