Re: [mdb-dev] Data type

[Christophe \CHiPs\ P. <ch...@ch...>]

Michele Monaco a =E9crit :
> I'm starting using the MDBTOOLS today...
>=20
> Really it seems to me a very powerful tool for an ACCESS user aspiring
> to switch himself in a MYSQL user.
>=20
> I started analysing one of my different Access DBs (really my chain to
> microsoft) with MDB-SCHEMA, in order to produce the relevant DDL, of
> which I attach a sample.
>=20
> The data type given by the mdbtools are not readable by the MySql
> Interpreter.
> For example Long Integer and Currency are not accepted by MySql.
>=20
> What can I do ?
>=20
> I have to make the necessary changes by hand or there is something
> automatic to convert the data type ?

Hello,

It seems that you have to specify the backend you want, default is to
output Access DDL. On my Debian SID, mdbtools version
0.5.99.0.6pre1.0.20051109-1, mdb-schema recognizes the mysql backend.

You have to launch it with :

$ mdb-schema mydatabase.mdb mysql > create-db.sql

HTH.

NB : Debian manpage is out of date, it does not speak of MySQL.

--=20
Christophe =ABCHiPs=BB PETIT <ch...@ch...> http://chips.free.fr=
/
=AB D=E9fendre les logiciels libres, c'est d=E9fendre la libert=E9. =BB
Linux-Nantes: partagez votre savoir http://www.linux-nantes.fr.eu.org/