Re: Informix to Oracle Conversion

->From: Dagmar Murray <DMURRAY@PURCCVM.BITNET> ->Subject: Informix to Oracle Conversion ->Date: Wed, 16 Feb 1994 18:53:20 GMT ->Reply-To: Dagmar Murray <DMURRAY@PURCCVM.BITNET> ->Organization: Purdue University -> ->I would like advice and recommendations on converting ->Informix databases and 4GL applications to Oracle. -> ->What experiences has anyone had with this process? -> ->What are the comparable Oracle tools? -> ->Are there conversion tools available? -> ->Thank you. ->---------------------------------------------------- -> ->Reply to: dmurray@oasis.cc.purdue.edu Good morning, Dagmar, I looked into this issue briefly some time ago, as a fall-back position for our project development in Informix. I am not aware of any commercial products to so such a conversion, but some may have come to market since I looked. The two hints I have regarding the conversion are: 1. PL*SQL is the Oracle product corresponding to Informix-4GL. The syntax is VERY similar. If no products are found to do the conversion, I am sure you could create a simple scanner that would do 90% or more of the conversion automatically. 2. Oracle does not have a data type corresponding to SERIAL. Oracle has a feature called a SEQUENCE, which performs the similar function of generating unique, sequential ID numbers. However, sequences are stored separately from the table holding the generated numbers. Sequences are treated as pseudo-tables, and contain the pseudo-columns NEXTVAL and CURRVAL. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\