I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Using a data modelling tool (like Dezign from
> Datanamic) or a scripting
> tool (like DbScripter), all you need do, I think, is
> load the Acces
Using a data modelling tool (like Dezign from Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is load the Access
database into the tool, configure the tool to create an export script
for MySQL (say, using InnoDB to enable FKs), touch up as desired, and
generate the s
Its my understanding you need InnoDB table types, but I do not know of the
single foreign key per table. I have a DB with multiple foreign keys per table
and its seems to work fine.
Bob
-Original Message-
From: Paun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 5:19 PM
To:
