Re: Migration data from informix to oracle

Hi veeratteshwaran

Client is not using GG.

On Wed, Oct 25, 2023, 16:28 Veeratteshwaran S <veeratteshwaran.s_at_gmail.com> wrote:

> Hello,
>
> Did you check on Oracle GoldenGate? However it is a licensed tool.
>
> Thanks,
> Veera
>
> On Wed, 25 Oct 2023 at 11:47 AM, Kim Berg Hansen <kibeha_at_gmail.com> wrote:
>
>> 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