Re: Migration data from informix to oracle

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_at_gmail.com> 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_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