Topic Thread

Expand all | Collapse all

MIgration From SQL Server /Oracle to Informix

  • 1.  MIgration From SQL Server /Oracle to Informix

    Posted Wed April 08, 2020 11:59 PM
    Hi 

    I try to find out the IBM Migration Toolkit if it is still available.
    Hope anybody know can share me the link. 

    Regards


    ------------------------------
    ABeMie
    ------------------------------


  • 2.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Thu April 09, 2020 02:08 AM
    Edited by SangGyu Jeong Thu April 09, 2020 02:21 AM
    Hello ABeMie,
    MTK is no longer provided by IBM. MTK has been replaced by IDMT and Database Conversion Workbench, but Informix is not supported. In fact, there are a number of alternative migration tools, such as Linked Server, IBM CDC, Oracle Gateway, Talend, Pentaho.
    If you need version 2.0.5.1 that I have, please leave your email address.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 3.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Thu April 09, 2020 04:48 AM
    Too bad they don't support it anymore because it does cool things. No comments beyond that because they would be bitter comments :-)


    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------



  • 4.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Thu April 16, 2020 11:30 PM
    HI 

    Are you able to run the MTK in your workstation/laptop.?
    If yes, can u share me what Windows OS you are using , Java version and etc.

    I have tried against my latop WIn10 plus Java RE 1.8 but the GUI crash with  java error.

    //

    ------------------------------
    ABeMie
    ------------------------------



  • 5.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Fri April 17, 2020 01:51 AM
    Hi ABeMie,
    Below is the screen where I ran MTK in windows 10 pro and jre 1.8 environment.


    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 6.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Fri April 17, 2020 02:58 AM

    Hi

     

     

    It works for me, at least launching

     

    I run on Win 10, java build 1.8.0_241-b07

     

    Would be cool it R&D could resume back on this product, I don't care about the 10452 versions of DB2 presented in the product, but I do care about checking deep how it works on  14.10 for instance.

     

    This product has been hidden to public visibility and it should not, unless someone wants to promote migrations from Informix to NON IBM DBMS ?

     

    R&D Tools team could take a look at it...

     






  • 7.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Thu April 09, 2020 04:47 AM
    I have it. Please PM me

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------



  • 8.  RE: MIgration From SQL Server /Oracle to Informix

    Posted Thu April 09, 2020 09:51 AM
    @ABeMie,
    Replicating the data from the other vendors to Informix might be the way to go. I can attest to CDC ​in combination with a 3rd party SW called SQDR from StarQuest. We are replicating Informix, Oracle and SQL Server data to an Aurora database in AWS and it works pretty good, from synchronizing an empty target database to keeping it up to date close to online.
    As always, YMMV.

    R

    ------------------------------
    Ramon Rey
    Any opinions I express here are my own and not the views of my employer.
    ------------------------------