Re: Converting AS/400 Data to HP9000 HPUX Informix

akroche@aol.com (AKRoche) wrote: :Does anyone have any experience migrating an AS/400 database to Informix? :The database exists on both the AS/400 and in Informix. The tables are :identical in format. There is no referential integrity at the database :level on either machine - that's currently all handled at the application :level. :Our biggest challenge appears to be just getting the data onto the 9000. :We tried FTP but had problems with packed numeric fields. We currently :have a manual process that "works" but requires that we download each file :from the AS/400 to a PC and then upload the file from the PC to the 9000. :It's not a large db (2GB) but we have about 300 tables to convert. Since :our conversion window will be a day (maybe two if we're lucky) over a :weekend, speed is important... :Any help would be appreciated. There are of course middleware solutions from different companies, but they are probably far to expensive for a one time conversion. There are however ODBC drivers available for the AS/400 to run on a PC that may not be too expensive. With only 2GB of data this may run fast enough that you can write a small program (in Visual Basic or whatever) that transfers all the data automatically using ODBC from the AS/400 and to the Informix database via the PC. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company