Re: dBASE (xbase) to Informix

Joseph P DeCello III (decello@discovery.uucp) wrote: : Is it reasonable to assume that I'll be able to get the : data from *.dbf files to Informix without retyping any of the data. Yes. : I realize it may be semi-automatic at best, maybe running reports from : dbase to ASCII files, then importing these into Informix. I guess this would be the easiest way to handle it. Since you only have to do it once for each database, there is not much sense in investing too much effort in creating an automated process. I have done imports from Foxbase to Informix a few times. One problem I encountered was that Foxbase prints strings enclosed in quotes, which I had to strip before doing the dbload in informix. No problem with sed. I would consider redesigning the database when doing the transition from dBase to Informix. It could be valuable to fully normalize the data model, which often is not the case in dBase. : I need to assure others here, that this indeed will be feasible before : convincing them to switch to any Unix based database system. Anything will be better than DOS/dBase :-))) Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+