Re: Data type

Thank you very much.

It runs well now.

Michele


2006/2/5, Christophe CHiPs Petit <[email protected]>:
>
> 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 <[email protected]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>