RE: Migrating from Informix 7 DW to Oracle 10g?

RE: Migrating from Informix 7 DW to Oracle 10g?

 

  

We just did one to 9i.
Use the High performance loader in Informix to unload the data. And then
import the data into oracle.
To convert the schema you can use a tool like Erwin or use the dbschema
utility in Informix and manually change the schema.

Oracle takes a lot more work than Informix so be prepared to have to spend
more time for DB management.



-----Original Message-----
From: Ezekiel Filane
[mailto:oracledba-ezmlmshield-x67548177.[Email address protected]
Sent: Monday, January 30, 2006 8:09 AM
To: LazyDBA Discussion
Subject: Migrating from Informix 7 DW to Oracle 10g?

Hi There.

- Anyone who can provide me with step by step migration from Informix 7
to Oracle 10g

- Mybe a link to that or full documentation.

- Or if you have done this please share your experiences.

Thanks
Ezekiel

----------------------------------------------------------------------------
----
Please note: This e-mail and its contents are subject to a disclaimer
which can be viewed at http://www.woolworths.co.za/disclaimer. Should
you be unable to access the link please e-mail [Email address protected]
and a copy of the disclaimer will be e-mailed to you.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page