Re: Migrating Oracle 7.0 to Informix

oops.. I misread the post. sorry. DMS has tools to go FROM Informix TO Oracle. Not the other way around (at least not yet ;-)) In article <kbradley-ya02408000R2608971250520001@192.86.155.100>, kbradley@us.oracle.com (Kirk Bradley) wrote: > 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