Hi Kim
I couldn't able to understand much .. is ther any other way to migrate the
database from informix to oracle.
On Fri, Oct 20, 2023, 13:20 Shravan Kumar Kota <shravankota@xxxxxxxxx>
wrote:
Hi Kim
Thank you for your reply, definitely I will try and let you know
the result.
Thanks
Shravan
On Fri, Oct 20, 2023, 13:16 Kim Berg Hansen <kibeha@xxxxxxxxx> wrote:
Hi, Shravan
If you have an OLE-DB (or alternatively ODBC) driver for your Informix,
you can consider the Oracle ODP.NET driver and it's BulkCopy classes.
With those .NET classes, you can bulk copy (direct path insert) data from
almost any source into Oracle very efficiently.
You can do it with a relatively simple Powershell script.
Take a look at my presentation about the subject and accompanying GitHub
repository of examples:
https://bit.ly/powerhaul
https://github.com/kibeha/powerhauling
Something similar to the demo script 05-oledb-to-oracle.ps1 could
probably work for you.
Possibly you need to map datatypes - I don't know how Informix datatypes
match with similar datatypes in Oracle, like for example CLOBs/BLOBs. But
the ODP.NET BulkCopy classes tend to handle most datatypes well, in my
experience. You can experiment with a few tables with columns representing
all those datatypes you have that needs to be migrated.
Hope it helps. At least take a look and try it out. Possibly you have
special issues so this won't work, I can't guarantee it, but there's a
chance it'll work for you :-)
Cheerio
/Kim
Regards
Kim Berg Hansen
Oracle ACE Director
Author of Practical Oracle SQL
<https://www.apress.com/gp/book/9781484256169>
http://www.kibeha.dk
kibeha@xxxxxxxxx
@kibeha
<http://twitter.com/kibeha>
On Fri, Oct 20, 2023 at 5:01 AM Shravan Kumar Kota <shravankota@xxxxxxxxx>
wrote:
Hi excepts,
Can any one guide or provide steps to migrate data from informix to
oracle.
Thanks
Shravan.
