Re: How to import to Informix DB from Fox DB
If you can get the ODBC driver, I suggest you use the
Enterprise Gateway Manager. Instead of writing an ODBC
application to move data from FoxPro to Informix, you
should be able to do it via DBACCESS by running
connect to Informixdb;
insert into informixtable select * fromfoxprodb@egmserver:foxprotable
EGM (Enteprise Gateway Manager) transparently does
data type conversions.
Let me know if you need more information
Thanks,
-Manas
--- Paul Watson <paul@oninit.com> wrote:
> You'll still have to create the tables by hand, but
> use ODBC. I did
> this a couple of years back, using Access. ODBC
> from Access to FoxPro
> and in the same Access database ODBC to Informix,
> then it's just a
> straightforward Access query.
>
> LUQUE Valdivia Omar - DBA de Marina wrote:
> >
> > Hello,
> >
> > How can i import to Informix from a database
> FoxPro.
> > I have some aplications in County that run on
> FoxPro, and we want migrate the whole structure to
> Informix,of curse I can recreate the table with the
> new types of data accepted by informix, then to load
> all the data, but does exist any informix tool that
> transform this in automatic without making so much
> work...?
> >
> > Thanks
> >
> > Omar LUQUE Valdivia
> > DBA de Marina
> > Direcci'n de Telem'tica - Marina de Guerra del
> Per'
> > Av. La Marina Cdra. 36 s/n, La Perla - Callao,
> Lima - Peru
> > Telf : (511) 562-3800 (511) 562-3900 Ext. 2277
> 2265
> > E-mail : Luque001@marina.mil.pe
> <mailto:Luque001@marina.mil.pe>
> > Cel. 9 639-7201
> >
> > sending to informix-list
>
> --
> Paul Watson #
> Oninit Ltd # Growing old is mandatory
> Tel: +44 1436 672201 # Growing up is optional
> Fax: +44 1436 678693 #
> Mob: +44 7818 003457 #
> www.oninit.com #
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
sending to informix-list