Re: Converting data to Informix from PICK!

At 11:47 AM 6/26/96 -0400, Nick Nobbe wrote: >On 25 Jun 1996, P F SIEGEL wrote: > >> My company is moving from a Pick database to Informix. I need to transfer >> / convert only our data, not the application software (we have bought >> new). This is typical maufactuing data, orders, invoices, accounts, >> customers, inventory and the like. Has anyone done this? Can it be done [...] > for the new target tables. Bear in mind also that before you get > started gathering, you should make sure the existing old db is > as clean as possible. You could of course unload the data into > a large Ascii delimited flat file using the native export function > or report writer, transfer the file to your Iformix box, load > the file into one massive table using the Informix dbload (cool > utility), and then start building your tables using inserts. You may investigate the data "cleaning" tools, designed for warehousing, such as verity and vality (I think). They'll give you a report of the different types of data that you think are all one type (such as the 11 different values one guy found in the SEX column) and offer some way to clean them up, too. These companies specialize in data migration. Of course, I have no connections with any of them, it's just something you should check into. Good luck, Clem __________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: back in Menlo Park, California USA