Re: Oracle to Informix migration
> Date: Wed, 16 Nov 1994 22:27:37 +0000 (GMT) > From: Mark Lansley <mark@dsl.com> > To: Informix <informix-list@rmy.emory.edu> > Subject: Oracle to Informix migration > > What tools (if any) are available to migrate an Oracle 7 to Informix DSA 6 > Database. The source database(s) are going to be quite large (6GB +) with > a significant number of tables (1000+), so it would be ideal if it could > convert from an offline database export directy into Informix (of course > I'm probably being ambitious but if you don't ask you never get). > > And suggestions of sed-awk-perl-grep-gnash-bish-bash-bosh don't strike me > as workable with such a large volume of data. :-) > > Regards, Mark > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Mark Lansley <mark@dsl.com> | "Whoa!....Maybe I'll just pass > Druid Systems Ltd, UK | on my usual barking frenzy." > +44 932 571212 (Vce) 571552 (Fax) | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I did the inverse, moving from Informix to Oracle, but the same concepts should apply. I also did it for only a dozen tables, not 1000+. To move from Informix to Oracle, I wrote Informix 4GL reports that created Oracle SQL*Loader control and data files. I then used SQL*Loader to load the data into Oracle. Since the table structures changed very slightly between the two DBs, I handled the table changes as part of the report writing process; i.e., Informix reports "knew" about the table changes, but Oracle only dealt with correctly formatted SQL*Loader files. To go in the other direction, I would use either SQL*Plus or SQL*Report to write DBLoad control files and data. For such a large number of tables I would probably use the same tools to also build a script to run DBLoad the appropriate number of times with the correct combinations of control and data files. One final caveat: Don't expect to make the data transfer in one trip. Design your data unloaders and data loaders to work incrementally. I found this necessary with a database only a few percent the size of yours. Good luck, 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!) \\ /________________________) (____________________________\\