Re: Migration data from informix to oracle

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_at_kibeha.dk
_at_kibeha
<http://twitter.com/kibeha>

On Fri, Oct 20, 2023 at 5:01 AM Shravan Kumar Kota <shravankota_at_gmail.com> wrote:

> Hi excepts,
>
> Can any one guide or provide steps to migrate data from informix to oracle.
>
> Thanks
> Shravan.
>

--
http://www.freelists.org/webpage/oracle-l