Re: Migration data from informix to oracle

I don’t know Informix, sorry. I just gave a solution that will most likely work for almost any datasource that has an OLEDB or ODBC driver.

Maybe there’s a migration tool that knows both Informix and Oracle, I don’t know. Then I hope for someone else to answer 😉.

Cheerio
/Kim

On Wed, 25 Oct 2023 at 06.47, Shravan Kumar Kota <shravankota_at_gmail.com> wrote:

> 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-l