Re: Migration data from informix to oracle
Date: Wed, 25 Oct 2023 10:17:10 +0530
Message-ID: <CAOzpM0-gmVMkY3zdH0L1AqUov4TEYE=nZ2AVAawzzwvKQn3j4g_at_mail.gmail.com>
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_at_gmail.com>
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_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-lReceived on Wed Oct 25 2023 - 06:47:10 CEST