Re: Migrating Oracle 7.0 to Informix

Art S. Kagel wrote: > > 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 Thank you very much. Very impressed for such a quick reply. However, How hard would you say is it to recode those SP, considering how apart are the two worlds ? Have you had any experience in this ? As you may notice, we are a little confused here and need any help anybody can provide. Best regards, Cesar