Thanks everyone for great advice!
Tom's question below is also interesting.
Also, are there data compatibility/integrity issues moving from Windows/MS
Access to Linux/MySql? I know that Linux is case sensitive and MySql wants
dates to be stored as -mm-dd. Does anyone know of other issues?
Thanks again
Arthur
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: Convert MS Access to MySql
question... does anyone know how it sets up the indexes, security
preferences , relationships..??? I mean does it do this or does it just
create the tables and upload the data???
Thanks Tom T
At 06:01 PM 12/22/2003 +0100, you wrote:
Arthur
Get DBManager Professional (for free) here :
http://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
-Ursprüngliche Nachricht-
Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 21. Dezember 2003 19:00
An: [EMAIL PROTECTED]
Betreff: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would
like to know the best way to do this. I was going to write an
asp or php script that would read the MS Access db row by row
and insert into the MySql db row by row. Is that the only way
to move the data from the one db to the other?
Many thanks
Arthur
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mann Library
Cornell University
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]