Re: Data type

Thank you very much.


It runs well now.


Michele

2006/2/5, Christophe CHiPs Petit <chips@xxxxxxxxxxxxxxx>:

Michele Monaco a écrit :
> I'm starting using the MDBTOOLS today...
>
> Really it seems to me a very powerful tool for an ACCESS user aspiring
> to switch himself in a MYSQL user.
>
> 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.
>
> 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.
>
> What can I do ?
>
> 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.

--
Christophe «CHiPs» PETIT <chips@xxxxxxxxxxxxxxx> http://chips.free.fr/
« Défendre les logiciels libres, c'est défendre la liberté. »
Linux-Nantes: partagez votre savoir http://www.linux-nantes.fr.eu.org/


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmdlnk&kid3432&bid#0486&dat1642
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev