Re: Migrating Oracle 7.0 to Informix

Posted in 1997

Art S. Kagel — Thu, 21 Aug 1997 15:06:26 -0400 — source: Informix-list mailing list archive (1991-1998)

Cesar Cruzado wrote: > > Anybody there had any experience pertaining this subject ? > Basic questions are : > - Stored Procedures. Installation has lots of SP's (some as long as 5000 > lines!). Is there any tool that could "convert" Oracle SP to Informix SP > sytanx ? Any tip that may help ? I am certain that you will just have to recode the SPs. > - Sequence number generators. You do not need sequence generators. Informix has a SERIAL data type which automatically maintains a unique, strictly increasing key. > - Data Migration. Just export to ASCII delimited files. Only dates and times can cause problems. Informix has equivalent datatypes to all of the Oracle types. Dates and times are handles enough differently to cause some grief, though. But a PSQL program can easily be written to export dates and times into (POSIX) standard formats that Informix understands. Best of luck and welcome to the community. Art S. Kagel