How to import to Informix DB from Fox DB

Posted in 2003

LUQUE Valdivia Omar - DBA de Marina — Fri, 5 Sep 2003 09:55:51 -0500 — source: Usenet: comp.databases.informix

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

↪ replying to LUQUE Valdivia Omar - DBA de Marina

John Carlson — Fri, 05 Sep 2003 13:14:31 -0400 — source: Usenet: comp.databases.informix

On Fri, 5 Sep 2003 09:55:51 -0500, "LUQUE Valdivia Omar - DBA de Marina" <luque001@marina.mil.pe> 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 Nothing to simple, unless FoxPro accepts ODBC connections. Is there a way to unload the data in FoxPro to a flat file??

↪ replying to LUQUE Valdivia Omar - DBA de Marina

Paul Watson — Fri, 05 Sep 2003 19:18:36 +0100 — source: Usenet: comp.databases.informix

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 #