Re: Migrating Oracle 7.0 to Informix

Contact your Oracle rep. we have tools to handle a lot of this automatically. They're provided by Design and Migration Services. In article <33FCA426.78D0@hotmail.com>, cesarcr@hotmail.com wrote: > 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